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.
N5755VArnold Alan Dale · Glenwood Springs, CON5755WSchmidt Mia H · Van Nuys, CAN57562Sitter Timothy L · Anchorage, AKFirst renewal noticeN5756BWages Brent · Rupert, IDN5756FStewart Larry E · Seymour, INN5756QDominguez Juan · Austin, TXN5756YLamascus Mark S · King City, CAN5757BWilson Chad R · Port Angeles, WAN5757CRoberts Justin · Livingston, MTN5757D57 Delta LLC · Grand Prairie, TXN5757EFlex Air Inc · San Diego, CAN5757FWaletzko David L · Avon, MNN5757JAdams Gary A · Alva, OKN5757WN63e LLC · Fallon, NVN5758BBentley John · Bend, ORN5758FTipnis Zachary Arjun · Troy, NYN5758JBatchelder Wesley · Palacios, TXN5758PBarr Michael J · Colorado Springs, CON5758QAviation Forza Inc · Pompano Beach, FLN5758VNelson Mike R · Philip, SDN5759FGelnett Dean A · Lansdale, PAN5759JThree Six Golf Ltd · Cary, NCN5759PDemars Michael · California, MDN5759WChimera Air Inc · Maumee, OHN575AAHanson Dirk Allen · Moorhead, MNN575ATAtp Aircraft 3 LLC · Wilmington, DEN575BFreedom Flight Inc · Southlake, TXN575BBZielich Matthew · Glendale, AZN575BLSolera Aviation LLC · Bozeman, MTN575CDG2 Aero LLC · Chattanooga, TNN575CKKincer Charles L · Richmond, MEN575DCArmadillo Aviation LLC · Hummelstown, PAN575DGSeamount Robert E · Milton Freewater, ORN575DKTextron Aviation Employees Flying Club Inc · Wichita, KSN575DSGotfredson Allen S · Ten Sleep, WYN575GMSouthern Aircraft Consultancy Inc Trustee · Casper, WYN575GWNeuse Aviation LLC · Smithfield, NCN575HBHot Damn Flying Service LLC · Palm Coast, FLN575JHDunbar Stephen E Trustee · Broken Arrow, OKN575L575 LLC · Fairbanks, AKN575MKEngstad Kai · Gig Harbor, WAN575NDAir Shares LLC · Casper, WYN575NVSouthern Aircraft Consultancy Inc Trustee · Casper, WYN575PAGrw Air Services LLC · Springport, INN575PMLiebfried Andrew H · Lunenburg, MAN575RVEzzo Donna L · Lancaster, NYN575SDBlue Sky Aviation LLC · Menominee, MIN575SLPhipps Vaughn Pago · Chattanooga, TNN575SPCharlie Leasing LLC · Green Bay, WIN575SWHester Thomas F · Santa Barbara, CA
Back to AD 2007-04-19 R1