AD 85-11-07 R1
Registered aircraft · 471
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:85-11-07-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:85-11-07-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:85-11-07-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:85-11-07-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.
N3210PKilcullen Brian DBA · Fort Lauderdale, FLN321BLWalls Bruce · Middletown, OHN323DCFlymax Aircraft LLC · Ball Ground, GAN325RPN325rp Corp · Willow Spring, NCN339DGRegistered aircraftN34KFRsb Properties LLC · Lewes, DEN34VFRomag Air Services Inc · Mc Lean, VAN350GZValiair Lc Trustee · Casper, WYN350LCDaly Arthur P · El Paso, TXN3605PSmith Bryan · Wenatchee, WAN36RWBas Part Sales LLC · Greeley, CON373ARPaul Brightwell Dirtworks Inc · Springer, OKN3745PRiviera Aircraft Inc · Lewes, DEN3761PSky Rollers LLC · Merritt Island, FLN3799PCt Services LLC · Albuquerque, NMN37MJLara-Meza Sergio Giovanni · Mcallen, TXN3829PRalphs Thomas A · Solana Beach, CAN3862PBrown Travis Trustee · Columbia, MON3886PUncanny Valley Films Inc · Arroyo Seco, NMN38AZN731ny LLC · Phoenix, AZN3912PRegistered aircraftN3959POmaha Aircraft LLC · Blair, NEN3EM3em LLC · Karnack, TXN3KPAllied Asset Management LLC · Oklahoma City, OKN401MPFriend Ships · Lake Charles, LAN403SWheeler James · Shreveport, LAN410ABBloxsom Allan P III · Boerne, TXN42CWHollywood Of The South Flight School Ltd · Decatur, GAN42WBCity Of Mesa Arizona · Mesa, AZN433BPLeverock Richard C · Port Saint Lucie, FLN43CPMountain View Industries LLC · Missoula, MTN43MEEvans Matthew B · Granbury, TXN4422NValiair Lc Trustee · Casper, WYN44475Jerryair Ltd · Kent, OHN44CCoyne Greg · Hondo, TXN4500KEaston Gregory D · Montrose, CON450CSCbcb Aircraft LLC · Colfax, WAN450SCSky West Aviation Inc Trustee · Albuquerque, NMN450SEAok LLC · Omaha, NEN4522KGoodman Jack A · Memphis, TNN456BRPressurized LLC · Sequim, WAN4570KHead East Aviation LLC · Geneseo, ILN4576KPope James Dean · Lewiston, IDN4580KHarrah Daniel R · Juneau, AKN4601WMike Papa LLC · Newton, KSN4610KAvag Inc · Richvale, CAN4612KChitiea Andrew D · Centennial, CON4617WSavoldelli Steven · Los Angeles, CAN4624KHoyt Matthew P · Newport Beach, CAN4626KWyeth Patrick B Trustee · Chino Valley, AZ
Back to AD 85-11-07 R1