AD 2002-23-06
Registered aircraft · 16,325
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:2002-23-06')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-23-06')
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:2002-23-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-23-06') 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.
N11151Kowest Aviation LLC · Enid, OKN1117PD W Shimoda LLC · Itasca, ILN111AJBergin Donald M · Ormond Beach, FLN111CFGsm Tax & Insurance Inc · Naples, FLN111CKSouthard Brian K · Las Cruces, NMN111DLCresence LLC · Port Saint Lucie, FLN111DSStarflight Aviation Inc · Wilmington, DEN111DVSouthern Aircraft Consultancy Inc Trustee · Casper, WYN111EWimpy Scott · Griffin, GAN111FCWoody Air LLC · Vero Beach, FLN111FFGutierrez Isaias · Fontana, CAN111GAGeorges Aviation Services Inc · Honolulu, HIN111HYSch Aviation Inc Trustee · NorfolkN111KDWedekemper Steven E · Brighton, MIN111LFZimmerman Leland · Center, CON111LUSchaefer Robert Lee · Orange, CAN111MBTinder John A · Rancho Cucamonga, CAN111MWSaratoga 181 LLC · Mesa, AZN111MYMeshed Networx LLC · New Market, VAN111NWKnell LLC · Casper, WYN111PKScruggs Ken · Galloway, OHN111SEKeith Fischer · Gig Harbor, WAN111SLKaehlert Lottie DBA · Rifle, CON111SNHalbert Kevin · Tyler, TXN111SXJcccs Land And Cattle LLC · Harrisburg, NEN111UCRcht LLC · Mason, OHN111WYN111wy LLC · Wilmington, DEN111XTPatch Aero LLC · Boca Raton, FLN111XWUnited Air LLC · Walnut Creek, CAN1122EVasey Igor · San Francisco, CAN1123FUrsus Air Services · Anchorage, AKN1125GBlue Knot LLC · Teguesta, FLN1126CBriggs Jonathan · Merritt Island, FLN1129PBonzo Air LLC · Saint Petersburg, FLN112ADfss LLC · Henderson, NVN112AANestor Richard · Portsmouth, NHN112CPBradley Aviation LLC · Columbus, INN112HDJackson Larry D · Orlando, FLN112JJNovember Alpha LLC · Dover, DEN112KGMedore Douglas A · Romoland, CAN112RMAppalachian Aviation LLC · Harrisonburg, VAN112SMReisdorfer Mark J · La Follette, TNN112WMInternational Air Services Inc Trustee · Carson City, NVN112WSEdgeington Randall K · Riverton, WYN1132QWattum Investments LLC · Kodiak, AKN1134DFma Auto Sales LLC · Greensboro, NCN11379Bas Part Sales LLC · Greeley, CON1137Y412 Jackson Site Development LLC · Oxford, MSN1139LMathewson Crews Aviation LLC · Indianapolis, INN113ACInternational Air Services Inc Trustee · Carson City, NV
Back to AD 2002-23-06