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.
N7003VKing Nine Aviation LLC · Lusby, MDN7004AMitchell Mark A · Pittsford, NYN7004EBoughan Patrick W · Vail, CON7004HFox Larry D · Hinton, WVN7004VPrice Gregory L · Kyle, TXN7005AStansell Clayton H · Los Lunas, NMN7005FUS Flight Academy International Inc DBA · Post, TXN7005TSmith Roy B · Newland, NCN7006AFletcher John G · Diamondhead, MSN7006ELienke Kevin E · Beaver Dam, WIN7006SSpicer Greg · Portage, MIN7006TFraas Stephan H · Meriden, CTN7007APreferred Aircraft LLC · Missoula, MTN7007MDouble 07 Mike Flyers Inc · Kalispell, MTN7007SJw Air Ventures LLC · New Smyrna Beach, FLN7008SPoe John B · Port Orange, FLN7008TDelaney Patrick James · Marion, TXN7008VMcclain John A · Olympia, WAFirst renewal noticeN7009ESutton Aircraft Salvage LLC · Palmer, AKN7009TCrigler Christopher E · Warrenton, VAN700JBSwanberg Erik · Yorkville, ILN7010EVorpagel Richard H · Elkhorn, WIN7010TLuft Aviation Inc · Wilmington, DEN70116Scott Stephen A · El Dorado, ARN7011ALaursen Nancee S · Tarpon Springs, FLN7011ESimon James A · Daphne, ALN7011FGlow Medspa LLC · Spring Hill, TNN7012EGordy Melvin E · League City, TXN7012TL L B Ranch Ltd · Del Rio, TXN70137Crist Todd L · Derby, KSN7013EPerkey Dan K · Rockvale, TNN7013TJohnston Jeremy · Cedar Springs, MIN70145Potter Kent W · Laurel, MTN7014AWaller John Michael · Brownsville, TXN7014HHernandez Jorge L · Luthersville, GAN7014THill James T · Rock Hill, SCN7015ELovato Daniel C · Springville, CAN7015MWalters Larry L · Venango, NEN7016SCreed Stephen L · Hamilton, VAN70170Mcknight Brittany A · Juneau, AKN70179Smalbergher Dorin · Soldiers Grove, WIN7017AHodgens Phillip J · Saluda, SCN7017EWinn Larry V · Tucson, AZN7017MDoughty Robert W · Casa Grande, AZN7017SGladwin Stephen R · Pflugerville, TXN7017TSchubert Arthur Glen · Wilmington, NCN70181Morrone Siri K · Medinah, ILN70189Sibole John W · Mount Gretna, PAN7018AKilburn Daniel B · Worcester, MAN7018TWarner Terry S · Grants, NM
Back to AD 94-05-05 R1