AD 2002-11-07
Registered aircraft · 1,512
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2002-11-07')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-11-07')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2002-11-07') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-11-07') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N1604MMckinney John Merrill Jr · Bessemer, ALN1604WSteve Byrd Aviation LLC · Terrell, TXN1619WExecutive Aircraft Management LLC · Northport, ALN161ABSafford Aviation Service Inc · Coolidge, AZN1629WRegistered aircraftN-number assigned, not yet registeredN162DFFaford Aviation Leasing Co · Atherton, CAN163SPAgriflite Services Inc · Wakarusa, INN1648WKings Aviation Corp · Garden City, NYN166BVSensing Aviation LLC · Nashville, TNN1673WOci Ltd · Brunswick, GAN167TRBarton Aviation LLC · San Antonio, TXN168CCLanham Aviation LLC · Simpsonville, KYN169RRGerlach & Associates LLC · Valparaiso, INN16DADonaire Aviation LLC · Tampa, FLN16PMcmurray Justin John · Durham, NCN1717SXp Silva Air LLC · Rockaway, NJN171DFDkg Motorized Conveyances Inc · Beaverton, ORN1748WBas Part Sales LLC · Greeley, CON174URocky Mountain Ventures Inc · Cheyenne, WYN17577James Rodney D · Bono, ARN17604Montgomery Aviation Corp · Montgomery, ALN17660Simpson Chad · Harrison, ARN17732Wright Brian L · Franklin, TNN177ABKostroski Larry J · Tucson, AZN177DGHesperia Construction Inc DBA · Ramona, CAN17820Evergreen Flying Service Inc · Rayville, LAN17833Mccall Edmund B · Portland, ORN17850Copeland Kenneth E · Rosie, ARN17979Alford Flying LLC · Wichita, KSN17980Rowles Robert · Pittsfield, ILN17BRJds Management Co LLC · Warner Robins, GAN17ESCrimson Aviation LLC · New York, NYN17GPRed River Partners LLC · Edmond, OKN1804WWillis Jerry · Jackson, MIN1806DGold Coast Logistics LLC · St Simons Island, GAN1807NDouble Barrel Aviation LLC · Fort Valley, GAN1808RFlorida Fence Corp · Tavernier, FLN1810XAviation Trust Company LLC Trustee · Oklahoma City, OKN1812WBolin Steven D · Odessa, TXN18142Aviation Trust Co LLC · Oklahoma City, OKN1815LEagles Rise Aviation LLC · Wales, MAN1817SClear Skies LLC · Stuart, FLN1817ZOrr Lynn E · Fredericksburg, OHN181JRCavu Clearing LLC · Palm Coast, FLN1827LCone James R Jr · Lubbock, TXN18280Team Holdings Inc · Sheridan, WYN18296Star Flight Aviation Inc · Shreveport, LAN1829ECorporate Airtime LLC · Clinton, MSN1830ZJaju Aviation Inc · Abilene, TXN18320Cox Jack H Jr · Arlington, TX
Back to AD 2002-11-07