AD 2003-01-01
Registered aircraft · 3,862
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:2003-01-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2003-01-01')
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:2003-01-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2003-01-01') 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.
N17703Dakota Aviation LLC · Sioux Falls, SDN17704Hall Thomas N · Dothan, ALN1772WRichland Flight Academy LLC · Sidney, MTN17748Montineri Joseph A · Port Orange, FLN17764N17764 LLC · Quincy, WAN17766Elworthy Steven M · Huntington Beach, CAN17769Jmk Engineering Inc · Bloomfield Hills, MIN17785Registered aircraftN17794Getting Dean W · Fort Dodge, IAN177SWGruslin Jean Pol G · Kingwood, TXN17817Dye Barrett · Abilene, TXN17819Mclendon Brian · Hawkins, TXN17826Three Six Bonita LLC · Georgetown, TXN17832Arrow Inc · Mount Sterling, KYN17833Mccall Edmund B · Portland, ORN17836Bear Dorvin L · Elida, OHN17838N17838 LLC · Scottsdale, AZN17863Loon Song Flyers LLC · Brookside, NJN17931Unlimited Sky LLC · Swansboro, NCN1794WSkyhawk Flying Club Inc · Omaha, NEN17979Alford Flying LLC · Wichita, KSN17980Rowles Robert · Pittsfield, ILN17BRJds Management Co LLC · Warner Robins, GAN17CDDroddy Charles V · Bryan, TXN17EARegistration Pending · Melbourne, FLRegistration pendingN17GVVolker Management LLC · Panama City Beach, FLN17USMarmac Inc · Hellertown, PAN17WNKadans Air LLC · West Bloomfield, MIN1800VRegistered aircraftN1801VSouthwind Aviation LLC · Hays, KSN1803XTrtt Investments LLC · Tahlequah, OKN1805DDodson International Parts Inc · Rantoul, KSN1805RFlying Ventures LLC · Middletown, DEN1806LHarrigan Timothy · Folsom, CAN1807BCloud Nine Corp · Batesville, INN1807FTurboflyers Inc · Leesburg, VAFirst renewal noticeN1807LCobra Industries Aeronautical · Wrightwood, CAN1807NDouble Barrel Aviation LLC · Fort Valley, GAN1808QBearspoint LLC · Edmond, OKN1809AHi-Ho Air LLC · Wilmington, DEN1810XAviation Trust Company LLC Trustee · Oklahoma City, OKN1811DRegistration Pending · Kennedale, TXRegistration pending, canceledN1811YCarhonik Enterprises LLC · Piney Flats, TNN1813BRr Aviation Services LLC · Wichita, KSN18142Aviation Trust Co LLC · Oklahoma City, OKN1814EErda LLC · Wilmington, DEN1814SUnited Mobile Auctions Aviation LLC · Mooresville, NCN1815FIss Holdings LLC · Lady Lake, FLN1817AKlinefelter Kristopher J · Phoenix, AZN1817LLorenzo Timothy A · Eureka, CA
Back to AD 2003-01-01