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.
N2673DAircraft Guaranty Corp Trustee · Oklahoma City, OKN2673GChapman Chad · San Antonio, TXN2673RDouville Laura Deluea · Portland, ORN2673SWilliams Randall S · Chico, CAN2673TZweig William D · Chesterfield, MON2673WAdolf Charles P · Ocala, FLN2673ZFiske James K · North Andover, MAN26743Lian Jay · Gold Beach, ORN26744Flying Tigers Flight School Ltd · Houston, TXN2674CTri County Sprayers Inc · Hamlin, TXN2674TCosgrove John W · Lake Ariel, PAN2674WHough Publishing LLC · Atlanta, GAN2674XKaiser Eric J · Milford, INN26757Terranova Jay · Lawrenceville, GAN26758Cooley Carolyn A · Bonifay, FLN2675DPaige Barry Wayne · Wasilla, AKN2675FVarnado Matthew G · Denham Springs, LAN2675TMahoney Dustin G · Lakewood, CON26760Davis Dana J · Pismo Beach, CAN26768Cheetah268 LLC · Kailua Kona, HIN2676BKero Jet Corporation · Montgomery, TXN2676GHolland Ross D · Guymon, OKN2676KFurey Michael J · Hazlehurst, MSN2676RStauter Michael D · Idabel, OKN2676TMills Nicolas A · Greenwood, NYN2676YHands Holdings · Newark, DEN2676ZFlynn Steven W · Bushnell, FLN26770Tuan Vo · Falls Church, VAN26778N26778 LLC · Santa Monica, CAN2677FNeu Aviation LLC · Benton, LAN2677GPeterson Barbara A · Cheney, KSN2677KAeropod Inc · Aurora, CON2677ST&D Janitorial Services LLC · Dexter, MON2677TDaggett Truck Lines Inc · Frazee, MNN2677WSaunders Charles A · Scott Depot, WVN2677XHawk Jeff · Flowermound, TXN2677YHracha Deanna L · Palmer, AKN2677ZWillkris Aviation Services LLC · Smithfield, VAN26780Campbell Joseph · Niceville, FLN26781Landon Easton Jeffrey Allen · Dresden, TNN26784Texas Cheetah LLC · Sugar Land, TXN26788Redwood Aircraft LLC · Santa Rosa, CAN2678SHardy Mikel Gareth · Thatcher, AZN2678TTekforce LLC · Boca Raton, FLN2678WLansford Company Inc · Lampasas, TXN2678XStewart Jeffrey D · Snyder, TXN2678ZKing Canyon Buffalo Inc · Denver, COFirst renewal noticeN26792Mayer David J · Ingleside, ILN26793Registered aircraftN26794Seveca Ventures LLC · Arcola, TX
Back to AD 2007-04-19 R1