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.
N3062SRiver City Aviation LLC · Carmichael, CAN3062WD M Aviation II Llp · Park River, NDN3062YSwaringen Jeanne A · Lakeside, CAN3062ZSchofield Wayne D · Polson, MTN30630Erickson Keith E · Anchorage, AKN30632Evv Pilots Club Inc · Evansville, INFirst renewal noticeN30634Beck Alan · Las Vegas, NVN30636Schub William C · Oakdale, NYN30637Diamond Paul · Londonderry, NHN30639Madden Michael A Trustee · De Pere, WIN3063DCase William M · Klamath Falls, ORN3063FT J Croach Llp · Post Falls, IDN3063PWillis William P Trustee · New Palestine, INN3063RGrant Scott A · Santa Barbara, CAN3063WReich Michael A · Woodside, CAN3063ZSeiter Randy R · Lake Isabella, MIN30643Hurst Gordon · Waterford, PAN30644Registered aircraftN30647Registration Pending · Diamondhead, MSRegistration pendingN3064DLebron R Luke · Gulfport, MSN3064WDavid And Shirley Houchin LLC · Crescent City, FLN3064YStemper Pete L · Madison, SDN3064ZReichlin Richard S · Traverse City, MIN30650Elite Flight Training And Aircraft Management LLC · Kankakee, ILN30654Eagle Sky Patrol Inc · Deadwood, SDN30656Vance Matthew Austin · Decatur, GAN30658Mcmahan Jerry · Watson, ARN3065CVenture West LLC · Mesa, AZN3065E3065e LLC · Westfield, PAN3065FHinds Frank E · San Angelo, TXN3065KBowles William Jr · New Richmond, OHN3065QSuchy Michael R · Murrieta, CAN3065RFlavin Patrick J · Woodbridge, VAN30661Feiler Joe · Casper, WYN30663Kroeker Bryan S · Grant, NEN30668Elevation Aviation LLC · Mccomb, MSN3066CBarham Micheal · Bluffton, OHN3066DN3066d LLC · Pompano Beach, FLN3066GAstro Aviation LLC · Cross Plains, TNN3066HLarsen Mark S · Spencer, IAN3066KQualitair LLC Trustee · MichelstadtN3066PMatanane Rokie C · Barrigada, GUN3066QMeyer Vernon C · Westlake, LAN3066RParker Michael A · Milwaukee, WIN3066YQuiett Aaron Trustee · Hillsboro, ORN30670Brown Thomas E · Trenton, GAN30671Foster Milton F · Dawson, GAN30673Cardinal Flyers Inc · Sault Sainte Marie, MIN3067CGoncharov Serge S · Monroe, NCN3067DLawson Roger E · Elizabethtown, KY
Back to AD 2007-04-19 R1