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.
N2742RCollinsworth Frederick W · Broken Arrow, OKN2742WStraub R L DBA · Stanton, TXN2742XCallaway Scott T · Soldotna, AKN2743FRiddle Danny M Trustee · Ruby Valley, NVN2743GFleetwood Jack · Hutto, TXN2743JColman Scott · Tampa, FLN2743QSzigeti David J · Gaylordsville, CTN2743XErb Weston Scott Trustee · Wasilla, AKN2744Morgan Jeff P · Justin, TXN27446Evans William Henry Jr · Gardendale, TXN2744CBrewer Farms · Thompson, MON2744FTyson Jacob N · Molena, GAN2744GShelton Jeffrey A · Denali Park, AKN2744JOvation Cwa LLC · Prairie Du Sac, WIN2744KLucas Greg C · Elmore City, OKN2744PTouchdown LLC · Pls Vrds Est, CAN2744VHerrenkohl Robert D · Bay Point, CAN2744WWilhelm LLC · Denver, COFirst renewal noticeN2744XAccelerated Slipstream LLC · Livermore, CAN2744YDe Vuyst Richard C · Pampa, TXN27457Felix Margarita G · Nogales, AZN2745FAlexander Production Co · San Antonio, TXN2745GKj3 Air LLC · Mitchell, SDN2745MNfh Aviation LLC · Pikeville, KYN2745PColgan Paulette · Tucson, AZN2745QAero Docs LLC · Butte, MTN2745ZKlabunde Andrew G · Menasha, WIN2746CChen Mark · Plano, TXN2746GMchugh Rick M · Enumclaw, WAN2746PParish Brandon · Mendon, UTN2746TFranklin Ronald C · Las Vegas, NVN2746YDavenport Jimmy J · Hayesville, NCN2747GVogt Mark Allen · San Diego, CAN2747JRamstad Phillip J Trustee · Anchorage, AKN2747PSvendsen Jon A · Wasilla, AKN2747QMosier Michael J · Kalamazoo, MIN2747RWilliams Dwight M · Paragould, ARN2747XTaylor Joseph Baker · Anchorage, AKN2747YJennflight Inc · Chagrin Falls, OHN2748FWirth Gerald J Trustee · New Lenox, ILN2748GNoe Aviation LLC · Vinton, IAN2748PHess Gary A · Petoskey, MIN2748QDavie Walter C · Los Angeles, CAN2748WZweifel Jonathan R · Chandler, AZN2749EB2fh Ltd · Allentown, NJN2749FSummersell Chadwick G · Chattanooga, TNN2749JFithian Cody D · Wasilla, AKN2749KAero Applicators Inc · Sterling, CON2749MBeebe Richard W II · Hamden, CTN2749YBaker Paul D · Grand Prairie, TX
Back to AD 2007-04-19 R1