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.
N9129RMckee Bradley Cole · Temple, TXN9130AKelsey Keith R · Grants, NMN9130DRoper Philip D · Wasilla, AKN9130UTravis Gary E · Raleigh, NCN91312Sloan John S · Murfreesboro, TNN9131AMcmurray Patrick T · Brush Prairie, WAN9131UVarivoda Marina Y · Miami, FLN9132DGorzynski Dustin B · Great Falls, MTN9132UBishop Michael J · Poulsbo, WAN9133AMeyer Jeremy · Conway Springs, KSN9134BJohnson Andrea J · Redlands, CAN9137BMeyer David E · Olathe, KSN9139BFikes Richard Glen III · Flint, TXN913PNWhitney James C · Olympia, WAN913SSMosher Duane · Lubbock, TXN9140BBunney Jared · Spokane Valley, WAN9140ULegore William G · Windsor, WIN9141ABarinaga Charles J · West Richland, WAN9141BBurnham Gary · Helper, UTN9141DEdburg Stan · Mead, WAN9143ACacka David A · Klamath Falls, ORN9143USherer Preston A · Watertown, WIN9144BMason Matthew L · Lincoln, ILN9145AWomack Wilbur A Jr · Jackson, LAN9145DMastre Ben T · Soldotna, AKN9145USharp Wayne H · Mena, ARN9146AHusser Marilyn G · Independence, ORN9147BReed Zane · Mountain Home, IDN9147DRiggin Flight Service Inc · Madison, SDN9149BFoust Kal E · Lenox, MIN914EYDreimiller Raymond J Jr · Bloomfield, NYN9150BHarral Blake · Prescott Valley, AZFirst renewal noticeN9151Joles Christopher A · Madison, OHN9151UAdvanced Aviation LLC · New Century, KSN91523Givens Eric J · Frankfort, OHN9153BMires James · Newnan, GAN9155AMaki Kevin L · Saginaw, MNN9156AStokes Jay M · Kingsland, TXN9156BRegistration Pending · Cheyenne, WYRegistration pendingN9156NBurdick Kenneth M · Swansea, MAN9156UHangar6 Aviation LLC · Apex, NCN9157BMighells Conrad E · Randolph, NYFirst renewal noticeN9157URoss Stephen D · Greenfield, OHN9159UHac Plane LLC · Sugar Land, TXN915BBBain Sterling Jr · Alexandria, LAN915WDRose Vicki · Beaverdam, VAN9160AAttitude Toys LLC · Wilmington, DEN9160BS & J Investments LLC · Sardis, MSN9161ACabral Aviation LLC · Milton, WAN9161BLee Mark S · Grove, OK
Back to AD 94-05-05 R1