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.
N1648WKings Aviation Corp · Garden City, NYN1650WGriffin Michael D · Madison, ALN165HPKessler William A Jr · Uvalde, TXN165JVHigh Desert Aviation And Aerobatics LLC · Pocatello, IDN166BVSensing Aviation LLC · Nashville, TNN1673THarvey Alan G · Dallas, TXN1673WOci Ltd · Brunswick, GAN167TRBarton Aviation LLC · San Antonio, TXN1687WAirway Management Inc · Wilmington, DEN168CCLanham Aviation LLC · Simpsonville, KYN168JGFlymore LLC · New City, NYN1694WKlauber James S Sr · Boonsboro, MDN1697WMountcastle Creek LLC · Pratt, KSN1699WDkp Holdings LLC · Melbourne Beach, FLN169GRBlue Skies Above LLC · Spring, TXN169RRGerlach & Associates LLC · Valparaiso, INN169TGNordic Sun LLC · Garner, NCN16DADonaire Aviation LLC · Tampa, FLN16EJAlphaalpha Aviation LLC · Paragould, ARN16NHRutgers Nicholas G IV · Camas, WAN16PMcmurray Justin John · Durham, NCN1706WHinton Bay Management LLC · Jackson, WYN1707WRussell Marc R · Simi Valley, CAN171CEGarrison Randy · Queen City, TXN171DDNorfolk Aircraft Interiors LLC · Virginia Beach, VAN171PBHarding Derrick S DBA · Adair, OKN171PFRegistration Pending · Los Osos, CARegistration pendingN1731WCollins Air LLC · Kennett, MON174TATracewings LLC · Goodyear, AZN174URocky Mountain Ventures Inc · Cheyenne, WYN17509Starke Charles H III · Weirsdale, FLN17520Patterson William · Spring, TXN1752WMichael S Austin Dmd Ms Psc · Utica, KYN1755WAis Construction Equip Corp · Grand Rapids, MIN17571De Oliveira Derek · Meadow Vista, CAN175LKern Charter Service Inc · Bakersfield, CAN17621Boe Mark · Morgan, UTN17628Elliot Air LLC · Dunwoody, GAN17639Peterson Eric S · San Jose, CAN1763W63 Whiskey LLC · Seattle, WAN17653Coggin Randall · Longview, TXN17660Simpson Chad · Harrison, ARN17668Broadway Travis A · Alexandria, LAN17669Srg Enterprises LLC · Montgomery, ALN17698Spindel Stuart H · Hawesville, KYN176DRKelly Daniel · Alpharetta, GAN176LFFour Basics LLC · Olathe, KSN176STCp A36 Inc · Knoxville, TNN176WHarwell Evin Dtrustee · Howell, MIN176XClub Turbo 176 LLC · Santa Clara, CA
Back to AD 2003-01-01