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.
N492RVRegistered aircraftN492SFSnohomish Flying Service Inc · Snohomish, WAN492SPChristiansen Aviation LLC · Wilmington, DEN492TZuestek Inc · Diana, TXN492TCMckinley Matthew · Sault Sainte Marie, MIN492WAirplane Adventures LLC · Palos Heights, ILN492WPAngel Aviation Inc · Peoria, AZN492XMcdonald Stuart D · Phoenix, AZN49305Everything Pitts LLC · Queen Creek, AZN49306Mercer Mark E · Aurora, CON49307Lutes David W · Berryton, KSN49309Newton Thomas L Jr · Fredericksburg, VAN4930ACapra Cory · Forest Lake, MNN4930LG Salisbury & Associates Inc · Prescott, AZN4930NOneill Aviation LLC · Lake Wales, FLN4930PRegion Flyers LLC · Valparaiso, INN4930RSouther Field Aviation Inc · Americus, GAN4930UUniversity Of Oklahoma · Norman, OKN4930VCirrusly LLC · Bonney Lake, WAN49312Boyd Timothy · East Point, KYN49314Losacker Matthew S · Chandler, AZN49315Morphew Ben · Mckinney, TXN49319Anderson Richard P · De Leon Springs, FLN4931CEinstein Inc · Price, UTN4931LThrust Spear Of Tampa LLC · Tampa, FLN4931RRegistration Pending · Westhope, NDRegistration pendingN4932ALegas David S · Phoenix, AZN4932JDunlap Aviation Inc · Dunlap, ILN4932NSan Juan Flyers Inc · Pagosa Springs, CON4932SThunder Aviation LLC · Oro Valley, AZN49330Cjw Hydrodynamics Inc · Fresno, TXN49331Plane Fun Inc Tr Trustee · Snellville, GAN49332Blue Eagle Pitts LLC · Tempe, AZN49335Van Cleave Raymond D · Kalispell, MTN49336Krieger Heinz Friedrich · FrenkendorfN49337Herrmann Ralf D · DahlemN49338Bakker Matthew G · Ellington, CTN49339Goble John H · Cresson, TXN4933JRegistration Pending · Columbia, SCRegistration pending, pending cancellationN4933LSouthall Charles B · Amelia, OHN4933QDarter Lloyd R · Mountain Grove, MON4933SHedden Larry H · Huntsville, ALN49340Butler Tracey D · Buckley, WAN49348Benner Tristen · Opheim, MTN49349Rankin Ty · Amarillo, TXN4934AYellowstone Overflight Inc · Belgrade, MTN4934EHeineman Steven · Chicago, ILN4934FAffordale Aviation Corp · Moriches, NYN4934LFlyboys LLC · Orange, VAN4934PAlm Holding LLC · Winton, CA
Back to AD 2007-04-19 R1