AD 94-05-05 R1
Registered aircraft · 26,230
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.
N8367UTb Maintenance And Cleaning LLC · Deltona, FLN8367XLawrence Robert J · West Point, VAN83683Hangar LLC · Vero Beach, FLN8368AOwens John P · Deland, FLN8368GClark Jeffrey S · Knoxville, TNN8368JVickers Lindsay · Fuquay Varina, NCN8368TYager James A · Scott City, KSN8368XGay Morgan C · Tunkhannock, PAN8369BO'Keefe Joseph G · Madera, CAN8369JDtm Enterprises Inc · Bronson, MIN8369UCamden Aviation LLC · Lewes, DEN836BLandrum Cristi C · Dallas, TXN836ECRichbourg Keith D · Waco, TXN8370BKline Nicholas J · Alliance, OHN8370GCarter Edward D · Ethel, MON8370JBrown David A · Lumberton, TXN8370TGreen Benjamin · Oro Valley, AZN8370USimonsen Joshua A · White Salmon, WAN83711Cameron Thomas J · Stanchfield, MNN8371MNosewheels Navy LLC · Rochester Hills, MIN8372AHegge Sharon D · Marysville, WAN8372JPaquette Michael J · Greene, NYN8372XN8372x LLC · Chelan, WAN83732Steenblik Jan W · Bloomington, INN8373AMcginn Robert W · Marion, NCN8373BSkyview Aviation LLC · Tracy, CAN8373GColumbia Asset Trust Corp Trustee · Wichita, KSN8373MBond Hiram E · Pls Vrds Est, CAN8373UKramer Mark S · Branchburg, NJN8373XPenrose Cory · Reno, NVN83746Alfredo Cordero · Mc Alpin, FLN8374AChilds Donald R · Wasilla, AKN8374BGardner Gilbert W · Hartford, KSN8375BRutan James · Palmer, AKN8375JAtlanta Aircraft Consultants LLC · Rex, GAN8375XDugan Ronald C · Rogers City, MIN8376BBilton Aircraft Management Inc · Umatilla, FLN8376XDraeger Joshua D · De Leon, TXN8377BLittle Eagle Valley LLC · Dover, DEN8377HRhodes Kent A · Seattle, WAN8377MBoyd Edward Lee · Apison, TNN8378MKuklo Robert M · Livermore, CAN8378UMartin Garland L · Zephyrhills, FLN8379ADedominicis Anthony J · Oneonta, NYN8379JLin Air LLC · Oviedo, FLN837BHendry Rickey · Apple Springs, TXN837GSims Hal C · Colleyville, TXN8380ALynch Henry D · Hebron, NHN8380BShull Thomas A · Copper Center, AKN8381BRaymond Kyle Inc · Eagle, CO
Back to AD 94-05-05 R1