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.
N105HFHeritage Asset Leasing LLC · Ronkonkoma, NYN105LULynn University · Boca Raton, FLN105NRState Of Minnesota · Grand Rapids, MNN10624Daytona Aircraft Leasing LLC · Daytona Beach, FLN10632Skyblue Aviation Cr Inc · Merritt Island, FLN1068YTextron Aviation Inc · Wichita, KSN106AFSoutheast Aircraft Leasing LLC · Jacksonville, FLN106EDEdwards Aero Club · Edwards Afb, CAN106ETFairmont State University · Fairmont, WVN106NKMenagerie Enterprises Inc DBA · Denison, TXN106RAChristiansen Aviation LLC · Wilmington, DEN106VKLumion Aviation LLC · Mountain View, CAN1071Z5280 Flying Club LLC · Castle Pines, CON1074XKelley Air LLC · Milford, MIN10782Kearbey Brandon · Hillsboro, ORN10797Federal Flight LLC · Fairfax, VAN107AFKummer Michael · Floyd'S Knobs, INN107ALAero Tech Services Inc · Lititz, PAN107APRegistration Pending · New Braunfels, TXRegistration pendingN107ELAa-Aero LLC · Lewes, DEN107PFConant Dakotah · Ocala, FLN1082JWild Bills Aviation Inc · Tustin, CAN1087CPhoenix East Aviation LLC · Daytona Beach, FLN10897Edb Air Inc · Wilsonville, ORN1089DHeavy Metal Air LLC · Farmingdale, NYN108CTDepartment Of Homeland Security · Washington, DCN108ED95 Msg/Svra Aero Club · Edwards Afb, CAN108HFHeritage Asset Leasing LLC · Ronkonkoma, NYN108PFKeith Wilcox & Sons Inc · Rexburg, IDN108PTHenrie Aviation LLC · Fairfield, NJN108TCAmeriflyers Of Texas Inc · Addison, TXN1090JRocky Mountain Flight Consultants LLC · Boulder, COFirst renewal noticeN1090VAviation Training LLC · Wilmington, DEN1090WMedary Aviation LLC · Brookings, SDN1092AGulf Coast Aviation LLC · New Orleans, LAN1097NSale Reported · Peoria, AZSale reportedN1097YAtlas Aviation Tampa Inc · Tampa, FLN109CPCivil Air Patrol · Maxwell Afb, ALN109LULynn University Inc · Boca Raton, FLN109TJLanier Equipment Leasing LLC · Gainesville, GAN10AVMaak Holdings LLC · Missoula, MTN10CXAlameda County Sheriffs Office · Livermore, CAN10YRAj Aviation LLC · Colby, KSN11019Cc Ventures LLC · Bowling Green, KYN11024Cao Wayne M · Dublin, CAN1104XFlight Training Aircraft LLC · Wilmington, DEN1107GLunken Flight Training Center LLC · Cincinnati, OHN110LULynn University Inc · Boca Raton, FLN110SQLand Air & Sea LLC · Concord, NCN1120ZWhite Wing Air LLC · Garden Grove, CA
Back to AD 2000-04-01