AD 90-04-06 R1
Registered aircraft · 68,377
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:90-04-06-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
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:90-04-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1') 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.
N4445SSkyborne Airline Academy Inc · Vero Beach, FLN4445VSkyborne Airline Academy Inc · Vero Beach, FLN4445YSkyborne Airline Academy Inc · Vero Beach, FLN4446JScherr Steven · Mandan, NDN4446RSiler Jerry L · Eau Claire, WIN4446ZGrant Kimberly A · Priest River, IDN44478Richard J Farmer II · Fremont, OHN4447EFucito Daniel Ross · Lexington Park, MDN4447MIndiana Aviation Inc · Nicktown, PAN4447QWolter Dennis R · Cincinnati, OHN44485Registration Pending · Middletown, OHRegistration pendingN44488Daris James · Fitzwilliam, NHN4448HNorthwest Iowa Flyers LLC · Everly, IAN4448THoughton John L · Lamar, MON4448ZGrow Michael J · Palmer, AKN44497English William E · Mason City, IAN4449CBell Investments LLC · Wasilla, AKN4449JSinatra Anthony J · Glendale, AZN4449MMoore David P · Chugiak, AKN4449ZStenga James E · Soldotna, AKN444APSmith Robert S · Orlando, FLN444AWHangar 22 LLC · Wilmington, DEN444BFBoogerd Bartel Jay · Atoka, TNN444BLTri Air LLC · Monette, ARN444CPMercure Ryan K · Eads, TNN444CSStover Charles S · Ft Lupton, CON444DBBalint Jozef · Fort Worth, TXN444DDHardin Donald D Trustee · Kirkwood, MON444DJSims George W III · Eclectic, ALN444DPStratospheric Ventures LLC · Saint Petersburg, FLN444DXRudeeair LLC · New Bern, NCN444EDunker Quinn E · Morse Bluff, NEN444EEVaughn Stewart C · West Jordan, UTN444EHJohafe Aviation LLC · Wilmington, DEN444FDJohnson Heimana J · San Marcos, CAN444FEN444fe LLC · Stuart, FLN444FGFrancis Andrew J III · Spring, TXN444HSCampi Curtis A · Boulder City, NVN444HUDorsey Sage · Bend, ORN444JGGrimmonpre Mark D · Fort Walton Beach, FLN444JLColby Christopher F · Hampton, VAN444JTFilho Aniz Rasslan · Payson, AZN444KCEdelman Douglas M · Sabetha, KSN444KPPerkins Kevin J · Wichita Falls, TXN444KRSmith Wylie J · Hawthorne, FLN444LMHumphrey William E · Lyndonville, VTN444LWWinn Larry V · Tucson, AZN444MAFirst Order Aeronautics LLC · Lees Summit, MON444MMAircraft Guaranty Corp Trustee · Oklahoma City, OKN444MRBuxbaum Mark Edward · Hot Springs, SD
Back to AD 90-04-06 R1