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.
N43091Reid Royce · Ferndale, WAN43094Auburn Aeroplane Inc · Ft Wayne, INN43095Rogers Danny · Florence, KYN43098Forest City Aviation Inc · Forest City, IAN43099Bennick Frances E · Andreas, PAN4309AParylak Sean P · Colchester, CTN4309JHorn Rodney L · Friendswood, TXN4309PSibille Philippe B · Waller, TXN4309QCamp Harold S Jr · Bossier City, LAN4309RWest Atlantic Transportation Corp · Mount Pleasant, NCN4309SGsi · Temple, TXN4309XFizer Charles Sutton IV · Orlando, FLN4309ZMccue Ryan D · Anchorage, AKN430ABAerial Banners Inc · Pembroke Pines, FLN430AVN1534x LLC · Manassas, VAN430BSCoyle Christopher Neal · Portland, ORN430BZHirschman David M · Ijamsville, MDN430CACivil Air Patrol · Maxwell Afb, ALN430CPCivil Air Patrol · Maxwell Afb, ALN430DBIkard James C · Shelbyville, TNN430DERotorwing LLC · Sheffield, ILN430DHHolbrook Dennis V · New Plymouth, IDN430DPNorthbound & Down LLC · Lexington, KYN430DSDelaware State University · Dover, DEN430EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN430FMaucione Debra T · Cloudcroft, NMN430FMCygnus Inc · Sioux Falls, SDN430FSCustom Air International LLC · Homestead, FLN430HHuntsinger Robert J · Bothell, WAN430JPAuchincloss John W · Weston, CTN430KUlve Scott David · Camdenton, MON430LRLee Aviation Services LLC · Wilson, NCN430MMMersereau Iden H · Goodyear, AZN430NDUniversity Of North Dakota · Grand Forks, NDN430REldredge Kevin E · Deer Park, WAN430RMRocky Mountain College · Billings, MTN430RPSale Reported · Billings, MTSale reportedN430RVVermejo Aviation LLC · Boulder, CON430SDMedary Aviation LLC · Brookings, SDN430TRight Wing Left Wing Flyers LLC · Cleveland, GAN430TCNorth Star Aviation Inc · Mankato, MNN430TLAgold Terry G · Tehachapi, CAFirst renewal noticeN430YClark Samuel · Shoemakersville, PAN430ZAlpha Tango Aircraft LLC · Wilmington, DEN4310DMessing Ted A · Locust Grove, GAN4310FKomair Inc · Smallwood, NYN4310PChimera Air Inc · Maumee, OHN4310QRonceverte Fliers Incorporated · Asbury, WVN4310SVelk Vincent F · Havre, MTN4310WSt Clair Joseph M · Wills Point, TX
Back to AD 2007-04-19 R1