AD 89-10-11 R1
Registered aircraft · 855
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:89-10-11-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:89-10-11-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:89-10-11-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:89-10-11-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.
N295CAChem-Air LLC · Shreveport, LAN2963WRegistered aircraftN-number assigned, not yet registeredN297CAHelicopter Services Of Illinois LLC · Fisher, ILN2995WScotts Helicopter Services Inc · Le Sueur, MNN299TBChemair Helicopters Inc · Jefferson, WIN29HXHelicopter Express LLC · Chamblee, GAN29SHelicopters Inc · Cahokia, ILN2FGRmc Aviation LLC · Klamath Falls, ORN301PDPeter Claire Ltd · GeorgetownN304PDCity Of Tucson Police Department · Tucson, AZN305GLTickety Boo Consulting LLC · Whitefish, MTN305PDCity Of Tucson · Tucson, AZN306FWEgli Air Haul Inc · King Salmon, AKN306PDCity Of Tucson Police Department · Tucson, AZN307RDHelicopter Services Of Illinois LLC · Fisher, ILN308LCLeon County Sheriffs Office · Tallahassee, FLN311FValley River Leasing Inc · Murphy, NCN312JPTomlinson Aviation Inc · Ormond Beach, FLN313APWav Series LLC · Batavia, ILN313MBSri Sky LLC · Madison, WIN315RDDc Leasing LLC · Cedar Falls, IAN316CFLeading Edge Flight Academy LLC · Bend, ORN316RCHelicopter Emergency Lift Program · Pomona, NYN316TVAero Products · Show Low, AZN3172COlson Marine Inc · Ward Cove, AKN317JPTomlinson Aviation Inc · Ormond Beach, FLN3188ZFulton County Police Headquarters · Atlanta, GAN3192G3192 Golf Inc · Wauchula, FLN3196GUSA Helicopter Inc · West Winfield, NYN31ATHelicopter Leasing Inc · Coral Gables, FLN3202DPapa Mike Aviation LLC · Dousman, WIN3202QDavid Lee Aircraft Sales And Leasing LLC · Wilmington, DEN320CMDyvig Enteprises LLC · Northwood, IAN3211NTumbleweed Leasing Co Inc · Salt Lake City, UTN321AWBolin William E · Smithville, OHN322ECDivesa Aviation Services LLC · Missoula, MTN322NBlue Sky LLC · Anchorage, AKN324CMClarke Environmental Mosquito Management · Roselle, ILN32KYEnglish Air Service LLC · Santa Maria, CAN331MHKt Auburndale LLC · Panama City Beach, FLN332MHXtreme Aviation LLC · Falkville, ALN333FCGolden Ranch Aviation Inc · Raceland, LAN333LWBohica Consulting Service Of Nevada Inc · Boulder City, NVN334KCHawk Hollow Farm LLC · Brighton, MIN335DMSmith Steven Lee · Whitehall, MTN3399Scotts Helicopter Service · Le Sueur, MNN33QPAir Metro Helicopter Inc · New City, NYN345RRChemair Helicopters Inc · Jefferson, WIN346ERCibaoair Aviation Group Inc · Middletown, DEN34CTCorporate Auto Brokers Inc DBA · Cleveland, GA
Back to AD 89-10-11 R1