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.
N7210WN7210w Corp · Selma, NCN7211DThacker William E · Chenoa, ILN7211JGolden Arrow Transportation · Plainfield, NJN7211KWalker Dean M · Fort Collins, CON7211RDavis Michael D · Danville, VAN7211YBeers Jason · Girard, OHN7212FDe Valle Rafael · Columbus, GAN7212GMeister James A · Star Prairie, WIN7212JF7 Aviation LLC · Kalispell, MTN7212QLink Air Service LLC · Minong, WIN7212WFerki Joseph J · Franklin, VAN7213DFranklin Gary B · Willcox, AZN7213QChain O Lakes Flying Club & Co Inc · Waupaca, WIN7213WSmith Scott V · Presque Isle, MEN7214EZachrison Marty · Spring Hill, FLN7214JFalcon Flyers LLC · Hamilton, MTN7214PKilmer Robert · Valentine, NEN72159Geiger William G · New Castle, KYN7215DSchmidt Wilfred L III · Elgin, ILN7215FGailie Thomas E · Middletown, NYN7215QRhynette Airways LLC · Key Largo, FLN7216FBravo Aviation Assets LLC · Akron, OHN7216GLincoln Skyways Inc · Lincoln, CAN7216JCaden Aviation Services LLC · Dallas, TXN7216PFerrara Antonio · Granbury, TXN7216QElias Close Deanna · Kenilworth, ILN7216WBim Merle Robert W III · Piqua, OHN7216YMerriwether David E · Whitesburg, GAN7217FWheeler Samuel C · O Fallon, MON7217GOne Niner Right LLC · Berkeley, CAN7217JAvionraton LLC · Valparaiso, INN7217QRegistration Pending · Fond Du Lac, WIRegistration pendingN7218DDuvall Brian G · Palmer, AKN7218JSullivan Michael D · Braddyville, IAN7218KRanstead Mark · North Granby, CTN7218PMclain Samuel · Hico, TXN7218WIsaacs Gorden R · Dillingham, AKN7219JJohnson Eric A · Shell Knob, MON721AAGammage Linda L · Delanco, NJN721AEAltomare Edmond J · Sarasota, FLN721AMLorenz Matthew J · Lakeland, FLN721BStandel David · Jacksonville, FLN721CBLung Brian · Williamsburg, OHN721DBBraden Denver · San Marcos, CAN721DLFour Stars Aviation LLC · Mckinney, TXN721EFRegistered aircraftN721ETHummel Alan Jay · Indianola, IAN721FJ8th Dimension Enterprises LLC · Aurora, ORN721HHHawaii Pacific Aviation Inc · Kailua Kona, HIN721HLZermeno Ira · Visalia, CA
Back to AD 90-04-06 R1