AD 2000-04-01
Registered aircraft · 5,676
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-04-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-04-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-04-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-04-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.
N1444CFlight Operations Aircraft LLC · Wilmington, DEN1447LHall Daniel W · Westlake Village, CAN1448ZNational Training 1 LLC · Wilmington, DEN1449CAb Prop Plane I LLC · Metairie, LAN144CKClover Park Technical College · Lakewood, WAN144GRegistration Pending · Waco, TXRegistration pendingN144MEBell Enterprises Inc · Falls Church, VAN1458HMosle Air LLC · Far Hills, NJN145HFHeritage Asset Leasing LLC · Ronkonkoma, NYN145MEAbdelmotal Elsadig · Pearland, TXN1460TJlj Aviation LLC · Amarillo, TXN14623Aircraft Guaranty Corp Trustee · Oklahoma City, OKN1463FSun Aircraft Management LLC · Ormond Beach, FLN1464CEdb Air Inc · Wilsonville, ORN14669Lowman Henry B Trustee · El Granada, CAN1468EMachado Donald C Jr · Honolulu, HIN146NEAngle Mark W · Lake Orion, MIN146TCN146tc LLC · Minneapolis, MNN146WHAmick Ralph O · Hatteras, NCN1472PFlight School Of Texas LLC · Wilmington, DEN147GWAllen Air LLC · Creola, ALN147HAPhoenix East Aviation LLC · Daytona Beach, FLN147PASetki Air LLC · Wilmington, DEN147SASteeda Autosports Inc · Pompano Beach, FLN14814Florida Flight Training Center Inc · Venice, FLN14829Ssea Properties LLC · Double Oak, TXN1484BMann Aviation Inc · Long Beach, CAN1488CChristiansen Aviation LLC · Wilmington, DEN1488TTanana Leasing LLC · Fairbanks, AKN148DWVantage Aviation USA LLC · Tampa, FLN148SMSarasota Westwind Flyers Inc · Sarasota, FLN149DWRbf Aero · Wilmington, DEN149LAColumbia Leasing LLC · Hillsboro, ORN149MEMccrary Mike M · Fairhope, ALN149UDW Air LLC · Chicago, ILN14PVRogers Michael P · Neenah, WIN14WGWest Coast Equipment Leasing LLC · Aurora, ORFirst renewal noticeN14WLTextron Aviation Inc · Wichita, KSN1502EElizbeth City State University · Elizabeth City, NCN15031Young J D · Plano, TXN1507XGolf November Aero LLC · Sunnyvale, CAN150SUOhio State University · Columbus, OHN150TESummit Air LLC · San Diego, CAN150TH150th Aero Flying Club · Morristown, NJN151BSEvans Linda J · North Wales, PAN151MELoweth William A · Noank, CTN151ZGSale Reported · Hood River, ORSale reportedN15206Megwetch Aviation LLC · Auburn, MEN15222Southeast Aircraft Leasing LLC · Jacksonville, FLN1522RN1522r LLC · Mequon, WI
Back to AD 2000-04-01