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.
N117SDLong Joseph F · Carroll, OHN117SVFlight Operations Aircraft LLC · Wilmington, DEN11802N11802 LLC · Bradenton, FLN1180NWinkelmann Aerospace LLC · Malabar, FLN1188LAyah Investments LLC · Kent, WAN118EGSpring Hill Aviation LLC · Cincinnati, OHN118ETL & W Leasing LLC · Smyrna, TNN118FSTfs Air LLC · Loveland, CON118KSKent State University · Stow, OHN118SVChristiansen Aviation LLC · Wilmington, DEN1190DCds Enterprise Group LLC · Ionia, MIN1196MAtlas Aviation LLC · Buckhannon, WVN1197LBoothe Vincent A · Fairhope, ALN1199DSpacely Space Sprockets LLC · Aurora, ORN1199HWingsleasing LLC · Wichita, KSN119FEnhancement Group LLC · Ocean Springs, MSN119KSKent State University · Stow, OHN119PWMeyer Peter W · Stevensville, MDN119SJetkinect LLC · Henderson, NVN11LJHandyquick Mn LLC · Woodbury, MNN1200VTampa Bay Aviation Inc · Clearwater, FLN1201EN1201e LLC · Wilmington, DEN1206Parks Bob C · Big Spring, TXN12064Eastern Cincinnati Aviation Inc · Batavia, OHN1206UFxe Flightcenter Corp · Fort Lauderdale, FLN120FMRunamuck LLC · New Orleans, LAN120GRStarlight Flight Aerial Tours LLC · Coppell, TXN120SUOklahoma State University · Stillwater, OKN1210KChristiansen Aviation LLC · Wilmington, DEN1215GValley Wide Engineering And Construction Inc · Trona, CAN12185Textron Aviation Inc · Wichita, KSN1218SSkyvibe Leasing LLC · Aurora, ORN121CPCivil Air Patrol · Maxwell Afb, ALN121CWAerostar Training Services LLC · Kissimmee, FLN121UCEastern Cincinnati Aviation Inc · Batavia, OHN121WN121w LLC · Union Gap, WAN121WEMidwest Aviation Inc · Mayfield, KYN1221Sky West Aviation Inc Trustee · Albuquerque, NMN1229KTextron Aviation Inc · Wichita, KSN122BCChristiansen Aviation LLC · Wilmington, DEN122DTFine Point Aviation LLC · Carrollton, GAN122MENorton Mark Trustee · Stateline, NVN122VKWings Over Texas Holdings LLC · Denton, TXN122WEOhio State University · Columbus, OHN1230GFlight Training Aircraft LLC · Wilmington, DEN1232GDirty Side Down Aviation LLC · Georgetown, TXN1235ESale Reported · Lewes, DESale reportedN12386Fly White Cloud LLC · Lake Havasu City, AZN123ARRullan Alberto · Adjuntas, PRN123CPCivil Air Patrol · Maxwell Afb, AL
Back to AD 2000-04-01