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.
N123GG150th Aero Flying Club · Morristown, NJN123PBTextron Aviation Inc · Wichita, KSN123PFJet Air Inc · Iowa City, IAN123VKAtp Aircraft 1 LLC · Wilmington, DEN12419Fort Wayne Aircraft LLC · Fort Wayne, INN1242BMustang Sally Aviation LLC · Camden, SCN1242NBg-Ip LLC · Saratoga, CAN124CKChristiansen Aviation LLC · Wilmington, DEN124EFGuerrer Daniel S · Redondo Beach, CAN124HFHeritage Asset Leasing LLC · Ronkonkoma, NYN124LLLyonfish Aviation Holdings LLC · Wellington, FLN124MEJet Air Inc · Iowa City, IAN124PLL & W Leasing LLC · Smyrna, TNN124WEMidwest Aviation Inc · Mayfield, KYN1250KChristiansen Aviation LLC · Wilmington, DEN12522Island Root Aviation LLC · West Palm Beach, FLN1252EStedje Timothy M · Gruver, TXN1254DAmeriflyers Of Texas Inc · Addison, TXN1258FRsns LLC · Snowflake, AZN125ALNby Productions · Bristow, VAN125LFHubbard Capital LLC · Nashville, TNN125LGWheat Travis W · Henderson, NVN125MDMaryland Aviation Administration · Bwi Airport, MDN125TWSmith Susan · Scottsdale, AZN125WEOhio State University · Columbus, OHN125WWRegistered aircraftN1260KChristiansen Aviation LLC · Wilmington, DEN1261Evy Holdings Inc · White Marsh, MDN126AAAmerican Aviation Inc · Brooksville, FLN126AVN106ka LLC · Manassas, VAN126BSCape Island Aviation LLC · Millville, NJN126HFHeritage Asset Leasing LLC · Ronkonkoma, NYN126MEGlobal Flight Training Solutions Inc · Immokalee, FLFirst renewal noticeN126SPPilling Stephen · Southport, NCN1270KChristiansen Aviation LLC · Wilmington, DEN12730Silver Creek Aviation Services · Fort Worth, TXN1276AAir Land Ventures 3 LLC · Berwyn, PAN1277WRush Aviation Rentals Inc · Meridian, IDN127HFHeritage Asset Leasing LLC · Ronkonkoma, NYN127JEGillian Michael · Batavia, ILN127KWElizabeth City State University · Elizabeth City, NCN1280KChristiansen Aviation LLC · Wilmington, DEN1281QMaranatha Insurance Services Inc · Rancho Cucamonga, CAN1287ECrown Coast LLC · Costa Mesa, CAN1289YBravo Leasing LLC · Daytona Beach, FLN128SCIasco Flight Training Inc · Redding, CAN128SHCalifornia In Nice Inc DBA · San Jose, CAN1296MThacker Thomas L Trustee · Hurricane, UTN129HFHeritage Asset Leasing LLC · Ronkonkoma, NYN129KFf22 LLC · Scottsdale, AZ
Back to AD 2000-04-01