AD 2000-08-51
Registered aircraft · 44,183
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-08-51')
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-08-51')
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-08-51') 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-08-51') 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.
N1028FLunoe Leif C · Anchorage, AKN1028MWenz Michael D · Gillette, WYN1028RGarner Donald G · Greeley, CON1028WArt Air Partners LLC · Louisburg, NCN1029MHarris Charles T Trustee · Thousand Oaks, CAN102BMeyjes Gijsbert Posthumus · Cadillac, MIN102BNDelta State University · Cleveland, MSN102CDrain Alan K · Columbus, MTN102CCPj Squared LLC · San Antonio, TXN102CDSch Aviation Inc Trustee · Sporle Kings LynnN102CJJordan River Aviation LLC · Madisonville, KYN102DLP & G Trading Co Inc · Trenton, NJN102DWFlyboy Aviation LLC · Memphis, TNN102EREmbry Riddle Aeronautical University · Daytona Beach, FLN102FAMedic Choppers LLC · Springdale, ARN102FPN9817k LLC · Fredericksburg, VAN102HLKopp Michael · Reno, NVN102JJGrose Christopher E · San Antonio, TXN102JMHeld John S · Cincinnati, OHN102JRRutkosky John J DBA · Palm Coast, FLN102KWVentura Douglas · Cambridge, MDN102KYPatriot Aviation LLC · Rostraver Township, PAN102LTSandjuice LLC · Gainesville, FLN102PACorno Portafortuna LLC · Celina, TXN102PBDeland Air And Sea Brokerage Inc · Deland, FLN102PSHunt Jimmie · Leary, GAN102PTNion LLC · New Century, KSN102QAir N Travel LLC · Cannelburg, INN102RBLeuszler Robert L · Lenexa, KSN102SBfb Enterprises LLC · Larned, KSN102SRAircraft Guaranty Corp Trustee · Oklahoma City, OKN102WBArtemis Inc · Hauppauge, NYN102WCDac 2020 Inc · Skaneateles, NYN102WLBoyd Stanley E · Placitas, NMN102XRidley Benjamin · Jamesville, NYN1030RThomas Leasing Enterprise LLC · Troy, MIN1030WChalupa Air LLC · Dover, DEN10319Battle Creek Aero Club Inc · Kalamazoo, MIN1031RKeller Paul M · Sanford, NCN1031VIntelinair Geospatial LLC · Indianapolis, INN1031WBilco Air LLC · Danville, ILN10322Skyview Resources LLC · Holland, MIN1032VMatlock Jimmy R · Granbury, TXN1032WOhlinger Mark A · Copley, OHN1032ZHoffman Curtis A · Marlborough, MAN10332Tx Holdings · Hermosa Beach, CAN1033QKuhn Marcus J · Madison, WIN1033WPunci Aviation II LLC · Port Washington, WIN1034SSchlueter Jeffrey · Fernandina Beach, FLN1035NHiggins Michael S · Palatine, IL
Back to AD 2000-08-51