AD 2000-06-01
Registered aircraft · 39,302
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:2000-06-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:2000-06-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:2000-06-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:2000-06-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.
N10644American Flag Airlines Inc · Ft Lauderdale, FLN10645Dearborn Edward M · Acworth, GAN10647Kosko Stanley G · Seattle, WAN10649Seaplane Adventures LLC · Cheyenne, WYN1064VHenderson Robert J · Grass Lake, MIN10651Wampler Matthew T · Valles Mines, MON10653Loftin Jamie B · Shreveport, LAN10658Craigmyle William R · Cooperstown, NYN1065VRegistered aircraftN10661Colberg Sigurd E · Palmer, AKN10663General Aircraft Services LLC · Pendleton, ORN10669Loeppky Neal K · Seminole, TXN10679Samson Rene R · Lewiston, MEN1067LCollins Gene William · Manassas, VAN1067MShore Enterprises Of Gainesville LLC · Gainesville, FLN10681Chickasha Wings Inc · Chickasha, OKN10682Thomas Edward L · West Bend, WIN10683Burton Ryne W · Astoria, ILN10687Boatright William L · Colonial Beach, VAN10688Wilson Oscar O Jr · Kountze, TXFirst renewal noticeN10689Registered aircraftN1068FDubois Marcus S · Olive Branch, MSN1068MWolfenden Allen K · Rocklin, CAN10693Full Stop Aviation LLC · Union City, TNN1069VSmith Robert E · Nacogdoches, TXN106ESOliverson Lee Ann N · Sandy, UTN106GCJones Michael D · Warner Robins, GAN106GTGendron Paul F · Vero Beach, FLN106PKScarbrough Dean C · Deshler, OHN106PSScarrow James D · Jerome, IDN106RGCadena Edward R Jr · Houston, TXN106RMArmstrong Ronald W · Brownsville, TXN106UCInsuraclaim LLC · Boca Raton, FLN106WSMarriott Ed · Manhattan Beach, CAN1070VKrebs Michael · Elkhorn, WIN1071MJesperson Kenneth R · Ekalaka, MTN1071VAdvanced Disability Management Inc · Montgomery, TXN1072VHegrenes Bruce A · Duluth, MNN10732Hale Sidney B · Bonham, TXN10737Shelley Matthew A · Cleveland, NCN10738Lindsay Tyler R · Kimberly, IDN1073FFlydreams Aircraft Group Inc · Fort Lauderdale, FLN1073MScr Aviation LLC · Austin, TXN10741Rice Zachary N · Los Angeles, CAN10742Lewis Thomas R · Aransas Pass, TXN10747Smith James E · Port Charlotte, FLN10748Jensen David · Bronte, TXN10749Atg Capital Management LLC · New York, NYN1074FNorth River Air LLC · Fairbanks, AKN1074TIowa Lakes Community College · Estherville, IA
Back to AD 2000-06-01