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.
N56900Roberts Marcus · Vancouver, WAN56902G R Martin & Associates LLC · West Plains, MON5690CTailwinds Aircraft Holdings LLC · Harrisburg, NEN5690DRolfe Cameron R · San Mateo, CAN5690KAircraft Guaranty Corp Trustee · Oklahoma City, OKN5690UPena Flight Partners LLC · Oakland, CAN5690ZGold Aviation LLC · Greenville, SCN56918Virgil Osvaido J · Glendale, AZN5691KRegistration Pending · Shady Shores, TXRegistration pendingN5691MBrowning Robert F · Washington, DCN5691PCoady Michael · Taylorville, ILN5692JSeawings LLC · Holualoa, HIN5692KBeyer Greg R · Buffalo, MNN5692QOpen Air Aviation LLC · Colorado Springs, CON5692VI N K M & Associates Lllp · Columbia, MON5692WFollmer Harvey C III · Trout Run, PAN5692YSilverado Sales Inc · Orem, UTN56934Low Allen R · San Francisco, CAN56937Qualitair LLC Trustee · MichelstadtN5693KTateshima Satoshi · Los Angeles, CAN5693PBays Aviation LLC · Boerne, TXN5693QKaufman Ben · Liberty, UTN5693SChupp David · Abbeville, SCN56942Oracle Aviation LLC · Omaha, NEN56943Mcdowell David M · El Cajon, CAN56947Wings Of Hope · Chesterfield, MON5694AStyer David B · Pendleton, ORN5694BKrukow Jonathan L · Hampton, IAN5694HTischer William D · Shoreview, MNN5694UPlencner Robert E · Round Lake Beach, ILN5694WLange James R · Tempe, AZN56950Bodily Kent A · Washington, UTN56957Payne Glenn · Oregon, MON56958Jackson Michael L · Nixa, MOFirst renewal noticeN5695QBabb Douglas L · Telford, PAN5695W95whiskey LLC · Georgetown, MAN56964Lafollette Larry E · Strafford, MON56965Brazos River Aviation LLC · Plainview, TXN56966West David A · Astoria, ORN5696BSkyways Group · Albuquerque, NMN5696KLokey Kenneth R · Austin, TXN5696MHubbard Benjamin L · Quogue, NYN5696QTrilogy Alliance Group LLC · Kearney, NEN5696WGiglio Tom J · South Boston, VAN56970Simoneau Todd · Sandown, NHN56972Eby Aviation LLC · Duluth, GAN56973Baja Flyers Inc · San Diego, CAN56976Tate Bird L Jr · Hammond, NYN56977Evans Holland L · Danielsville, GAN56978Brindley James G · Collinsville, AL
Back to AD 2007-04-19 R1