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.
N3434RBurkhardt James · Brookings, SDN3434SDawsey Carl E · Long Beach, MSN3434UHale William R · Covina, CAN3434XAronhalt Daniel E · Columbus, INN34358Leap Aviation Inc · Wilmington, DEN3435EBober Aviation Mountain Flying LLC · Hayesville, NCN3435FDickens Frank K · Moncure, NCN3435NBailey Robert B · Damascus, ORN3435UJackson Terry W · Lewisburg, TNN3435XYeaw Norman E · Hazel Green, ALN3436ARegistered aircraftN3436FChinik James G · Jacksonville Beach, FLN3436RGressly Aviation LLC · Camp Verde, AZN3436WIsland Aviation Management LLC · Plainview, NYN3436XWebb Chris · Burns, TNN3436ZRasch Bernard A · Benton City, WAN34378Johnston Paul · Belleville, MIN3437FYankee Air LLC · Valdosta, GAN3437M7550g LLC · Birmingham, MIN3437QJamerson Kendall L · Bovina, TXN3437RSmith Darrin M · Torrance, CAN3437TRoberts John M · Mansfield, MON3437YLanding Gear Works LLC · Renton, WAN34380Ackerman Kurt · Kingman, AZN34383Crestair Air LLC · Dover, DEN34386Jopson Charles M · Etna, CAN34387Schoenborn Robert F · Folsom, CAN3438NDurst Luke · Panhandle, TXN3438RDauenhauer Colby · Springtown, TXN3438SAvco Patrol LLC · Lyndon, KSN3438UGrau Gary Wayne Jr · Yelm, WAN3438WBlue Wanderers · Fort Wayne, INN34391Harding Nelson · Lebanon, ORN34392Harding Nelson · Lebanon, ORN34393Registered aircraftN3439SProtsman Bryan D · Anchorage, AKN3439UFlycatcher Aviation LLC · Purcell, OKN343ABurleson Steven L · Las Vegas, NVN343AAAnding Paige E · Bryan, TXN343ABPonderosa 343 LLC · Richmond, VAN343ACRegistration Pending · Campbellsburg, KYRegistration pendingN343ASSilberman Allen · West Chester, PAN343BRendzio Robert J · Dothan, ALN343BGBowling Green Flight Center LLC · Bowling Green, OHN343CDMastin Air LLC · Dover, DEFirst renewal noticeN343CEDeriso Jordan L · Arcadia, FLN343CPCivil Air Patrol · Maxwell Afb, ALN343DBBrown Patrick T Trustee · Osceola, WIN343DMHess Eric J · Cave Creek, AZN343EDKobe Thomas J Jr · Lake Placid, FL
Back to AD 2007-04-19 R1