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.
N5147HBeyond Willpower Inc · Shreveport, LAN5147JN5147j LLC A Series Of Aero Lease LLC · San Antonio, TXN5147KCline Aircraft LLC · Mena, ARN5147LPerkins David W · Newburgh, INN5147PDunn Paul S Trustee · Santa Fe, NMN5147RKirkland Kerry G · Spring, TXN5147SBluegrass Aviation LLC · Clarksville, TNN5147UCox Coleman Haynie · Honea Path, SCN5147YN5147y LLC · Andover, MNN5148DNick Peak Flying LLC · Mccall, IDN5148EQuandary Consulting Group LLC · Greenwood Village, CON5148FBonura Rocco F Jr · Perkinston, MSN5148HMalad Aviation LLC · Bliss, IDN5148KHetteen David D · Camano Island, WAN5148PRegistered aircraftN5148SN7396w LLC · Coeymans Hollow, NYN5148VAyres Aviation LLC · Santa Monica, CAN51495Wallace State Community College · Hanceville, ALN5149EAce Of Spades Aviation LLC · Las Vegas, NVN5149KNorthwest Navion Inc · Arlington, WAN5149LBaker Jon M · Eugene, ORN5149R5149r LLC · Manhattan, MTN5149SPiper Aircraft Inc · Vero Beach, FLN5149VAlcock Alan D · Empire, CAN5149WThomas Clifford C · Madisonville, TNN5149XAmboni Sinesio Jr · Wasilla, AKN514APa28 Aircraft LLC · Wilmington, DEN514AVDigirolamo Anthony S · Stow, MAN514BDLepkowski Daniel P · Industry, PAN514BKNot For Naught LLC · Wimberley, TXN514BRJmb Aviation LLC · Iowa City, IAN514CMoore Aviation Inc · Beaver Falls, PAN514CBAnge LLC · Honolulu, HIN514CGFlight Training Aircraft LLC · Wilmington, DEN514CHWehrli Mark A · Missouri Valley, IAN514CSTomco Stores Ltd · Ruidoso, NMN514DMHock Steven R · Indian Hills, CON514DPPitts Donald W · Sand Springs, OKN514EDFarris Stephen L · Hickory, NCN514EEMeridian Aircraft LLC · Wilmington, DEN514FVenohr Robert E · Aurora, CON514FCState Of Alabama · Montgomery, ALN514FLLaurienzo Paul G · Portsmouth, RIN514GCCristan Gene V · Lake Mary, FLN514HPState Of Ohio / Department Of Public Safety · Columbus, OHN514HRSethi Inderdeep Singh · Tracy, CAN514JBSchneider Stephen C · Denton, TXN514JMCommercial Diving Inc · Melbourne, FLN514KValentin Arnaldo J · Bayamon, PRN514KCPerazzola Carl J · Bonaire, GA
Back to AD 2007-04-19 R1