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.
N3565KDb Dickinson Farms Inc · Brighton, IAFirst renewal noticeN3565MSix 5 Mike LLC · Shreveport, LAN3565PPavia Joshua A · Alamogordo, NMN3565YRegistration Pending · Conrad, MTRegistration pendingN3565ZLewis William D · Shelbyville, TNN35662Warbington Michael L · Enid, OKN35665Imes Rusty J · Greenacres, WAN35667Gamby John E · Chadron, NEN35668Schwartz Brenda A · San Angelo, TXN35669Selkirk Seaplanes LLC · Hayden, IDN3566ASun City Aviation LLC · Davie, FLN3566ECronk Jack L · Fallbrook, CAN3566PDobbin Douglas G · El Paso, TXN3566WGriffin Aviation LLC · Minneapolis, MNN3566YTocco Paul J · Crescent City, FLN35671Clemons Preston J · Andover, KSN35672Leaseair LLC · Wilmington, DEN35673Knutson Ronald J · Tacoma, WAN35675Scholand Gregory J · West Ossipee, NHN35677C3 Indutries LLC · Bakersfield, CAN35678Trone Gary L · Taylorville, ILN3567FPbj Skylane LLC · Sparks, NVN3567LGordon Robert E Jr · Holly Springs, NCN3567PWoolington James D · Dillingham, AKN3567QIosco Flying Club · East Tawas, MIN35680Pilot Studio LLC · Sabana Seca, PRN35683Dmac Aircraft LLC · Savannah, GAN35689Faulkison Brian S · Watkins, CON3568EColonial Air Inc · New Bedford, MAN3568UCsi Aviation LLC · Wilmington, DEN3568YAerial Adventures Demo Inc · Hopewell, VAN3568ZUelner Nathan · Cedar Falls, IAN35690Mcauliffe Pat · Collegeville, PAN35696Beisel Johnathan · Owasso, OKN3569DFtaviation LLC · Chantilly, VAN3569NPhp Air LLC · Oscoda, MIN3569UHelicopter Of Columbia LLC · Columbia, SCN3569WFossum Richard F · Salado, TXN3569XPrice Walter R · Beavercreek, OHN3569YSage Michael · Opelika, ALN3569ZKleewein Daniel A · Pewaukee, WIN356AKAris Aviation Group LLC · Henderson, NVN356ARPiper Aircraft Inc · Vero Beach, FLN356BFRegistered aircraftN356BGBowling Green Flight Center LLC · Bowling Green, OHN356CMOquinn Aaron Nathaniel · Anchorage, AKN356CPCivil Air Patrol · Maxwell Afb, ALN356DADragonfly Aviation LLC · Winder, GAN356DHCompass Rose Aviation LLC · Derby, KSN356DMMader Aaron J · Sheridan, WY
Back to AD 2007-04-19 R1