AD 2000-23-21
Registered aircraft · 47,138
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-23-21')
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-23-21')
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-23-21') 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-23-21') 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.
N180AFRegistered aircraftN180AGAg Leasing LLC · Wilmington, DEN180AHSwiss Arctic Flyers Inc · Lewes, DEN180AKBecker Kurt G · Dexter, NMN180ANJones Marvin B · Farmerville, LAN180APAir Plains Services Corp · Wellington, KSN180AQTracy Michael R · Santee, CAN180AXNoyes Abigail · North Pole, AKN180AYPerkins Paul Fortaine · Anchorage, AKN180AZMohr Elizabeth G · Brandon, MSN180BADavis Robert D · Camas, WAN180BBSouthern Aircraft Consultancy Inc Trustee · Casper, WYN180BDSanderson Bryan D · Emmett, IDN180BFComunale Anthony S · Roxbury, CTN180BGCmw Aircraft LLC · Hailey, IDN180BHMorris Christopher H · Valparaiso, INN180BRDainas Barry · Port Orange, FLN180BSSerie Dennis P · Chugiak, AKN180BTAerobug LLC · League City, TXN180BZFlying Red Birds LLC · Framingham, MAN180CBrown Hector M · Glenwood Springs, CON180CBSmith Dennis A Trustee · Salem, ORN180CDHicks P David · Heber City, UTN180CETailwinds Ranch LLC · Orlando, FLN180CJWipaire Inc · South Saint Paul, MNN180CRSnow Robert J · La Mesa, CAN180CTPerformance Paradise LLC · Eagle Harbor, MIN180CYYoung Ideas LLC · Post Falls, IDN180DProuty Edgar C Jr · Sebec, MEN180DAAalgaard Raymond F · Hollister, CAN180DCWilson Lewis G Jr · Rock Hill, SCN180DGHodnett Stephen T · Canadian, TXN180DHMarden Aero Services LLC · Erwinna, PAN180DJHuang Sophie M · Newcastle, WAN180DKGriffin Vaughn · Spirit Lake, IDN180DLHall John E · Duluth, MNN180DMMock David J · Mesa, AZN180DSCrawford E Clarke · Flagstaff, AZN180DTWalton Indy R · Soldotna, AKN180DUSchlegel Mark O · Kingman, KSN180DZAndrews Ruben · San Diego, CAN180ECDarb Inc · Lakeville, MNN180ELInternational Air Services Inc Trustee · Carson City, NVN180EMCustom Air Inc · Roe, ARN180ESRegistration Pending · Gillette, WYRegistration pendingN180ETHoffpauir Amanda E · Danevang, TXN180EVTuttle Medical Inc · Hurricane, UTN180EWWeaver George C · Oldtown, IDN180FCVdovich Derek D · Orr, MNN180FFMach.180 Airlines LLC · Denver, CO
Back to AD 2000-23-21