AD 94-05-05 R1
Registered aircraft · 26,232
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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.
N5622Nichols Stephen S · Hartland, WIN5622ANissley Stanley · Cottage Grove, TNN5622CBoyett Aviation LLC · Cumby, TXN5622RKv Enterprises LLC · Kalispell, MTN5623ABeskar Shawn P · Eagan, MNN5624ERound Engine Aero · Nashville, MIN5624FGunsch Matthew T · Phoenix, AZN5625CWhittlesey Leslie F · Dana Point, CAN5625FWilson Bobby R · Kathleen, GAN5626AAero Gravity Media Inc · Delray Beach, FLN5626GGreer Management LLC · Salem, ORN5626TWerkman James R · Scottdale, PAN56274Brown William H · Ravenna, TXN5627AKeiffer Robert P · Piney Flats, TNN5627RBitikofer Brent E · Kansas City, KSN5627TSchulte Lawrence · Griffin, GAN5628AMaldonado Alejandro · Minneapolis, MNN5628CEllis George T · Mt Chase, MEN5628GJewell Jonathan T · Paducah, KYN5628RKellam Garnett A · Mappsville, VAN5629CSchultz Philip W · Lancaster, CAN5629ECueva Arturo A · Los Angeles, CAN5629FShawn James Robert · Pattison, TXN5629MReihing Randall S · Whitehouse, OHN5629RSadie Hawk Aviation LLC · Collinsville, CTN5629T5629t LLC · Denison, TXN562GSHermann Andrew L · Kindred, NDN5630ABrockmeyer Cory · Auburn, ILN5630CMallamo John · Shell Knob, MON5630EHolliday Mark E · Lake Elmo, MNN5630MWilliams Richard M · Creston, IAN5630RLanas Flying Machine LLC · Hollywood, FLN5630TBolin Matthew R · Everett, WAN5631FHolladay Leonard R · Greeley, CON5632THodder Philip Michael · Houston, TXN5633CWinkler William P · Granbury, TXN5633RBirds Eye View LLC · Nampa, IDN5635ADecoteau Mitchel E · Yellville, ARN5635FMartinez Jose A · Pensacola, FLN5636AFine Aviation LLC · Jefferson, ORN5636EHirt David M · Marblehead, OHN5636RSkyhawk Aviation LLC · Ogden, UTN5636TRegistered aircraftN5637ASherman Frederick J · Tukwila, WAN5637FLong William M · Hemphill, TXN5637TBarbour George E Jr · Croydon, NHN5638AHartigan Robert P · Rome, NYN5638ENorthern Ventures II LLC · Missoula, MTN5638FFisk Christopher J · Hammonton, NJN5638RBurkhart Andrew · Toccoa, GA
Back to AD 94-05-05 R1