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.
N50958Stangel Richard C · Enterprise, ORN5095DTevik Michael A · Provo, UTN5095ESchroeder Michael L · Ayr, NDN5095RTraining Planes LLC · Tampa, FLN5095TColter Duane E · Plainfield, INN5095WBailey Bruce B · Dublin, VAN50967Sellers Raymond L · Trussville, ALN5096GRiya Aviation LLC · Tracy, CAN5096HMyhre Norman G · Hixton, WIN5096RProvestment International LLC · West Melbourne, FLN5096TRichards Lyle D · Riley, KSN5096XKanooth Michael L · Washougal, WAN5097EBenedikt Craig A · Clayton, GAN5097JFencer Michael J · Wilmington, MAN5097NDevericks Richard · Ventura, CAN5097QIntravaia Anthony J · Mountain View, CAN5097RPlymouth Flying Club Inc · Plymouth, NCN5097VCamm Air · Spencer, IAN5097YBlackburn Anthony C · Mcdonough, GAN50987Berg James O · Dunseith, NDN50988Propability One LLC · Daytona Beach, FLN5098DShepard Mark S · Malin, ORN5098NReed Kenneth C · Hollywood, MDN5098QM&L Engine LLC · Schriever, LAN5098RWilliams Austin T · Sheridan, INN5098SBadenhope John R · Greeneville, TNN5098VHarvestowne Aviation LLC · Saint Charles, MON5098XFontenot Reginald J · Church Point, LAN50996Burke John E · Spring, TXN5099CRinker Robert W Jr · Seattle, WAN5099KSaari Michael · Sycamore, ILN5099MBufo David · Los Osos, CAN5099NRabinowitz Jeffrey Evan · Akron, OHN5099PSelinger Richard L · Murrieta, CAN5099RFly High Aircraft Sales LLC · Ocilla, GAN5099TClark Darril W · Scappoose, ORN5099VNew Horizon Aviation Inc · Warwick, RIN5099XBailey Carlton D · Huntington, WVN509ANecochea Juan · Cedar Ridge, CAN509AFAmeriflyers Of Texas Inc · Addison, TXN509AMAmerican Asset Leasing LLC · Aurora, ORN509ARRegistered aircraftN509ATPollard Weldon Luke · Ardmore, OKN509AZPfisters Farm Aviation LLC · Pasco, WAN509BWAnderson Richard D Jr · Remus, MIN509CBHouseman Jeffery D · Millersville, MON509CDTfs Limited LLC · Scarborough, MEN509CETitle Associates LLC · Hurricane, UTN509DBMaycroft David E · Cary, ILN509DPX-Jet Logistics LLC · Chino Hills, CA
Back to AD 2007-04-19 R1