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.
N327MYankaitis Michael J · Mosinee, WIN327MBCaptain Steeeve LLC · N Topsail Beach, NCN327MSMason Phillip R · Jacksonville Beach, FLN327MWW. Morrison Consulting Group Inc · Aliso Viejo, CAN327NDUniversity Of North Dakota · Grand Forks, NDN327PFMo-Col Medical Services Inc · Kirksville, MON327PPEnglish Paul L Jr · Enterprise, ALN327RHInfineon Properties Of Montana LLC · Helena, MTN327RVEvans Ryan C · Scranton, NDN327SBSchultz Christopher A · Lake Forest, CAN327SPAmeriflyers Of Texas Inc · Addison, TXN327TALeblanc Joseph E Jr · Houston, TXN327XNew Horizon Aviation Inc · Warwick, RIN327ZDaj Aviation LLC · Manvel, TXN32801Registration Pending · Indianapolis, INRegistration pendingN32805Scheffler Frederick L · Corinth, KYN32806Nimsic Thomas L · Carson City, NVN32808Strander Chad A · Lodi, WIN3280FChristian Edward A · Evans, GAN3280PRiggin Flight Service Inc · Madison, SDN3280RAmson Technology Lc · Des Moines, IAN3280XCoastal Defense Inc · Mill Hall, PAN32813Clear Sky Investments LLC · Martinsville, INN32816Williamson Flying Club Inc · Williamson, NYN32817Keating William P · New Port Richey, FLN3281DRichardson John David · Willis, TXN3281FCapps Daniel Boyce · Newcastle, OKN3281KWallace Architects LLC · Columbia, MON3281SWright Flyers Club · Huber Heights, OHN32820Turner Douglas A · Sacramento, CAN32825Manning John E Jr · Sylacauga, ALN3282DLafleur Kerry P · Fort Worth, TXN3282QMaxwell Benjamin D · Collierville, TNN3282SWest Thomas Edward · Watsonville, CAN3282TCavu Aircraft Sales & Management Inc · Olyphant, PAN32830Mach One Over Six LLC · Atlanta, GAN32831Jochen Nathan D · Sevierville, TNN32832Brendel William B · China Spring, TXN32837Arias Aviation LLC · Hazle Township, PAN32838Brawders Stephen Andrew · Simi Valley, CAN3283BGay Morgan C · Tunkhannock, PAN3283DAllen Roger B · Gardnerville, NVN3283FMorgan Lance A · Georgetown, TXN3283WGlasgow Ronnie Kyle Jr · Guin, ALN32841Blue Sky West LLC · Tempe, AZN32846Coulter James A · Bakersfield, CAN32847International Air Services Inc Trustee · Carson City, NVN3284DKornfield Edward A · Anchorage, AKN3284FHicks Raymond K · Villa Rica, GAN3284REsser Jill · Mason, MI
Back to AD 2007-04-19 R1