AD 94-05-05 R1
Registered aircraft · 26,231
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.
N4267UZeiset Luke R · Manchester, TNN4268UWhitby Devin A · Dumfries, VAN4269FPerkey Gilbert J Jr · Eagle Rock, VAN4269LBussey Stuart · Lafayette, CAN4269NEdwards Bruce W · Palmer, AKN4269VDouglas Phillip A · Fredericktown, OHN426AMMarrero Edgardo · Enterprise, ALN42709Freed Richard H · Watervliet, MIN4270LDavenport Sam · Gail, TXN4270NAshley Edward A · San Antonio, TXN4270USilvia Scott A · Valley Springs, CAN4271ESchmidt Anthony D Jr · Jordan, MNN4271FStevens George C · Lake Leelanau, MIN4271LRoberts David W · Arden, NCN4272FCayton John C · Cameron, MON4272LStechbart Kurt E · Glendora, CAN4272VShaw Christopher · Porterville, CAFirst renewal noticeN4273FVan Wychen James G · Warrens, WIN4273ULykens Valley Aviation · Lykens, PAN4274FAppalachian Bible College Inc · Mount Hope, WVN42751Madsen James E · New Underwood, SDN4275FG & M Associates LLC · Quitman, GAN4275LBarney Jared L · Tully, NYN4276NWilliams Robert B · Bullard, TXN4277FMilitary And Civilian Aviation Heritage Foundation · Benton, PAN4277URegistration Pending · Anderson, SCRegistration pendingN42782Butcher Mike O · Big Lake, AKN4278NConley Jay · Saxonburg, PAN4278ULotze Stephen H · Burlington, WAN4278VDoherty Michael J · Le Sueur, MNN4279MWarner Daniel B · Hartland, VTN4279NQuevedo Joseph David · El Paso, TXN4279UEgolf Michael J · Cissna Park, ILN4279VCummins Gary L · Sunrise Beach, MON427JWDyer Ray R · Kalispell, MTN427KBSkorupa Anthony R · Bridger, MTN427LPPeasley Lisa M · Lakeville, MNN42806Kent Gary W · Salome, AZN4280LShellbourne Aviation LLC · Ormond Beach, FLN42815Hendershott Kevin · Vacaville, CAN4281FFour Winds Aviation LLC · Stigler, OKN4281LKiger Aviation LLC · Corvallis, ORN4281UUS Flight Academy Intl Inc · Post, TXN4281VWalko Ann-Marie · Westport Island, MEN4282EKuhn Darrell G · Irma, WIN4282FThomas Christopher D · Pacific Palisades, CAN4283AUsher Larry G · Simi Valley, CAN4283FMckee Jay R · Dixon, WYN4283UMills George Thomas · Lagrange, GAN42847Broadhurst W D · Jesup, GA
Back to AD 94-05-05 R1