AD 2000-23-21
Registered aircraft · 47,133
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.
N366CDAircraft Guaranty Corp Trustee · Oklahoma City, OKN366CPSnsg Properties LLC · Virginia Beach, VAN366DHummer Family Capital Aviation LLC · Boonton, NJN366DMSwaggart Paul Blake · Touchet, WAN366HPRey Del Cielo LLC · San Antonio, TXN366KWhite Thomas J · Agua Dulce, CAN366LDHorizon Aviation LLC · Johnson City, TNN366LFBank Of Utah Owner Trustee · Salt Lake City, UTN366PSkyway Unlimited Inc · New London, NCN366PSA-Team Family LLC · Ashland, ORN366PTCollins N366pt LLC · Franklin Lakes, NJN366PWEuroaviation Inc Trustee · KematenN366SGibbs John M · Monterey, CAN366TFMajul Enterprises Inc · Saint Petersburg, FLN366ZMendel Carl · Port Charlotte, FLN3670EFresh-Pic Harvest Inc · La Quinta, CAN3670UHoffman Kevin · Chatsworth, GAN3670YRoussin David G · Newville, ALN3671FHenson Ronald E · Bonita Springs, FLN3671HErickson Orchards Inc · Ritzville, WAN3671MFigvam LLC · New York, NYN36724Reeves Richard G · La Verne, CAN3672UD W Clark LLC · Newton, NJN3672YN3672y LLC · Ferrysburg, MIN3673RArtie Aircraft LLC · Trenton, MON3673UCastor Care LLC · Mount Pleasant, SCN3674DUS Flight Academy International Inc DBA · Post, TXN3674GSudduth Ronald C · Lineville, ALN3675CBergstrom Dean A · Watertown, CTN3675RCl1 LLC · Baton Rouge, LAN3675TFairbairn Stephen C · Carmel, INN3675YShettle Jay E · Berryville, VAN3676CBoyce Walter Doug · Palmer, AKN3676UGregg Michael · Orlando, FLN3677UNinomiya James T · Placitas, NMN36787Manairco Inc · Wooster, OHN3678UCaven Dennis L · Santa Rosa, CAN3678YDozier Zach J · New Boston, TXN36795Rudy Neal W · Peoria, ILN3679DCheney Joseph F · Daphne, ALN3679UPowerhouse Coach Inc · Idaho Falls, IDN3679ZKlein Eric · Tenino, WAN367ATL&R Aircrafts Corp · Boynton Beach, FLN367BCVc Air LLC · Midland, TXN367BMWilliams Richard · Atlanta, GAN367CPKafil Jason · Covina, CAN367DMarquardt James H · Warner Robins, GAN367HMCoastal Streets LLC · Marblehead, MAN367HPN367hp LLC · Aberdeen, SDN367KRYance International LLC · Mobile, AL
Back to AD 2000-23-21