AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N4192YDragon Grass LLC · Nashua, NHN4192ZSwanson Amos W · Palmer, AKN41937Calumet Aero LLC · Crown Point, INN4193RHunter Jeffrey Jay · Shreveport, LAN4193YVan Dorpe Ross · Saint Charles, ILN41940Moughty Matthew · New Haven, VTN41949Ferg Robert B · New London, WIN4194QJacques Jerry J · Iliamna, AKN4194SKilpatrick Bryan J · Poway, CAN4194WNicholson Jon S · Bethel, AKN4194YPyne James E · Tucson, AZN41954Up And Up Aviation LLC · Magnolia, TXN4195EHusky Central LLC · Hugo, OKN4195RPlain LLC · Traverse City, MIN41960Tiffin Aviation Services Inc · Nogales, AZN41963Schafer Gary L · Greenwood, DEN41966Wray Jimmy Don · White House, TNN41967Krog Steven L · Hartford, WIN41969Lazy 8 Aviation LLC · Arden, NCN4196DCub Club Incdba · Fort Myers, FLN4196GProuse Craig H · Groveland, CAN4196PHarmon Aviation LLC · Exeter, NHN41973Legacy Aviation LLC · Murfreesboro, TNN41977Augusti Group Enterprises Inc · Clayton, NCN41978Henderson Jason E · Corona, CAN4197CAll In Aviation LLC · Townville, SCN4197KRichardson Walter J Jr · Aliceville, ALN4197QSumner Properties LLC · Somersworth, NHN4197SIndependence Aviation Inc · Scottsdale, AZN4197XBarr Air Patrol LLC · Mesquite, TXN4197ZBurns Barry D · Amarillo, TXN41980Warren Donald E · Pine Bluff, ARN41983Brotherman LLC · Hereford, TXN41985Aerospace Systems And Training LLC · Orange City, FLN4198BAero Flight Flying Club · Minneapolis, MNN4198FRal Aviation LLC · Trumbull, CTN4198RTaf Aerial Services LLC · Beeville, TXN4198YGallo Michael R · High Falls, NYN4198ZMcfarlane Bradley J · Port Alsworth, AKN41990R H K Of Kansas Inc · Overland Park, KSN41992Stein Anthony J · Locust Grove, GAN41995Columbus State Community College · Columbus, OHFirst renewal noticeN41997Caae Leasing LLC · Lake Zurich, ILN4199HN4199h Club Llp · Oshkosh, WIN4199JHallenbeck Jesse · Bellingham, WAN4199TEnga James Craig · Madison, SDN4199ZSymanowski Kevin · Reeder, NDN419ACSimmons Scott · Anchorage, AKN419BCVagabond LLC · Baton Rouge, LAN419BEVolar La Vida LLC · Kalispell, MT
Back to AD 2007-04-19 R1