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.
N2DXLaw Coaching International · Irvine, CAN2EBCampbell Bernard D · Morehouse, MON2EEMatthews Mark A · Independence, ORN2EGKorver Kelvin M · Adams, NEN2EQSpatscheck Oliver · Denison, TXN2EYBender Jeffrey T · Scottsdale, AZN2FOrr Steven H · Murfreesboro, TNN2FKAshwath Nagaraj · Los Altos Hills, CAN2FLCharvet Andre Bennett · Titusville, FLN2FNFlying Neutrons LLC · Lebanon, OHN2GAWilson Frank C · Irondale, OHN2GDGarland Gary · Oakhurst, OKN2GHAbel Robert G · Williamstown, MAN2GRRichardson Gordon B II · Caldwell, TXN2GVKubecka Daniel P · Edna, TXN2GXFerrer Bryan A · Denver, CON2HABrunner Robert L · Jefferson, ORN2HDDelapp Douglas T · Placerville, CAN2HMRogers Zachary · Durham, NCN2JDHauf Daniel Ray · Jack, ALN2JGWetsu Enterprises Inc · Colorado Springs, CON2JJAerial Surveys International LLC · Watkins, CON2JKGoldberg Leonard J · Westbrook, CTN2JLLane John T · Calico Rock, ARN2JNPhillips Matthew L · Las Cruces, NMN2JUGlastar LLC · Ponte Vedra Beach, FLN2JVVan Grunsven Gerald B · Hillsboro, ORN2JXBrookeash Inc · Waxahachie, TXN2KAMorinaka Noble Jr · Nyssa, ORN2KBKb Aviation LLC · Mission Viejo, CAN2KFLivingston H Clark · Akron, ALN2KGLowe Samuel S III · Mary Esther, FLN2KMBas Part Sales LLC · Greeley, CON2KPWilliams Timothy L · Mckinney, TXN2LBSemler Jason S · Wasilla, AKN2LCStults Curt M · Choctaw, OKN2LHStotlar Richard L · Tucson, AZN2MAFlorida Air Leasing LLC · Gainesville, FLN2MBAlfa Foxtrot LLC · Statesville, NCN2MLMclaury Kim · Mission Hill, SDN2MMGlas Lease LLC · Austin, TXN2MTO'Leary John M · Fresno, CAN2MWCommand Aire LLC · Sitka, AKN2NUEkstrand Marshall C · Lake Stevens, WAN2NYBoyle Frederick W Sr · Cape May, NJN2NZFriedland Dana K Jr · Mountain Home, ARN2PEPeters Ronald · Lighthouse Point, FLN2PFFlying Cow Farm LLC · Mount Pleasant, ARN2PLIhnen Lewis M · Golden, ILN2PTWiger Theodore L · Falcon Heights, MN
Back to AD 2007-04-19 R1