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.
N52852Hultin Ronald · Rosemount, MNN52853Heintz David A · Culver, ORN52857Tdex Equipment · Abilene, TXN52858Channel Islands Aviation Inc · Camarillo, CAN52859Wehrs Aviation LLC · Johnsburg, ILN5285DBarker Aviation LLC · Ardmore, OKN5285GGlobe Motorcycles Limited Inc · Pembroke Pines, FLN5285HChild Cris · Mapleton, UTN5285JJensen Michael J Trustee · Sterling, AKN5285KBoland Mark J · Anchorage, AKN5285PFrank Investments Inc · Austin, TXN5285RPuddle Jumper Aviation LLC · Brighton, CON5285UShroyer Jayme D · Longmont, CON5285VMiddletown Regional Flight Training Institute LLC · Middletown, OHN5285YHanson O John · Kaycee, WYN52861Holst Thomas C · Pleasant Hope, MON52866Egan Bailey J · Forsyth, MTN5286CUnited Flying Club Inc · Belmont, CAN5286EButler Bill · Juntura, ORN5286GPaliughi Ronald D · Fresno, CAN5286HNieves Irvyn T · Vega Baja, PRN5286MSwift Aviation LLC · Silverdale, WAN5286TWilson Aviation LLC · Robinson, ILN5286WMonea Laurentiu · Brookline, NHN52873Pepper Daniel J · Henderson, TXN52876Noteboom Mike · Orange City, IAN52877Weight Malcom E · Spanish Fork, UTN5287ATax Busters Inc · El Paso, TXN5287DWitham Kyle S · Lakeview, ORN5287ELin LLC · Dunn, NCN5287GNoyes Stephen S · Newburyport, MAN5287PFogleman Brian L · Stonewall, LAN5287WStump Kenneth H · Ward, ARN5287YMorrow Aviation LLC · Midland, TXN52880Matta Sam · Houston, TXN52884Smith Eric Von Trustee · Vallejo, CAFirst renewal noticeN52886Gilbert Jack M · Visalia, CAN52888Alphadelta Aviation LLC · East Windsor, CTN52889Waters Steven D · Kingwood, TXN5288TG & S Air Adventures LLC · Jersey City, NJN5288WMcdowell John Michael · Auburn, CAN52891Registered aircraftN52895Marshall Brian L · Hays, KSN52899Kalogerson George G Trustee · Eden Prairie, MNN5289EFlightco Inc · Swainsboro, GAN5289GRounds Chris · Waller, TXN5289LJames Brandon · Maple Valley, WAN5289MHardy Caitlin M · Woodinville, WAN5289PVaughan Michael P · Northbridge, MAN5289SHarrison John M · Letart, WV
Back to AD 2007-04-19 R1