AD 79-10-14 R1
Registered aircraft · 56,582
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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.
N5383DTong Sheng Aviation LLC · Irvine, CAN5383KAmerican Patrols Inc · Midland, TXN5383NCivil Air Patrol Inc · Maxwell Afb, ALN5383QEight Three Quebec LLC · Arlington, VAN5383SScharber Patrick · Monticello, MNN5383TMeyers Morgan J · Twin Falls, IDN5383XWillard Raymond C · Wasilla, AKN5384Penhorwood Joshua M · Shubuta, MSN5384BGust Dale A · Boise, IDN5384CPrice Edsel B · Leesville, SCN5384KVascular Wings LLC · Friendswood, TXN5384NBlizzard Johnny F · Lake City, FLN5384RKidd Frank E Jr · Wilson, NCN5384TJohnson William R · Virginia Beach, VAN5385DDg Aviation Services Inc · Merritt Island, FLN5385HBeer Steve Z · Morristown, NJN5385JAerowood Aviation LLC · Monroe, NCN5385NTrevino Sergio A · Houston, TXN5386ATriplett And Adams Transport Partnership LLC · New Concord, OHN5386BTop Dogs LLC · Dickinson, NDN5386DDuffys Aircraft Sales & Leasing Inc · Neillsville, WIN5386JNaylor-Adams Aviation LLC · York, PAN5386RVargo Michael D · Fremont, OHN5386SDodson International Parts Inc · Rantoul, KSN5387CGoral William W · Redlands, CAN5387HStene Aviation Inc · Polson, MTFirst renewal noticeN5387KN5387k LLC · Carthage, NCN5387ROancea Traian · Oakdale, CAN5387SGoyer Jeffrey A · Houston, TXN5387TMagnusson Charles D · Upper Sandusky, OHN53885Gc Aviation Services-1 LLC · Miamisburg, OHN5388BBurak Steven W · Emmett, IDN5388YValiair Lc Trustee · Casper, WYN5389CRegistration Pending · Niagara, WIRegistration pendingN5389DRegistered aircraftN5389KMcconnell Cynthia D · New Smyrna Beach, FLN5389RTetrault David E · Largo, FLN5389TChadwell Letch J · Hulbert, OKN538CJav Air Services LLC · Anchorage, AKN538EREmbry-Riddle Aeronautical University Inc · Prescott, AZN538HFSun Aircraft Management LLC · Ormond Beach, FLN538KSKent State University · Stow, OHN538NDAerosim Academy Inc · Sanford, FLN538PCFontaine Scott M · Salt Lake City, UTN538SPRc Flying Partners LLC · Fair Oaks, CAN538TBCorum Richard E Jr · Clemmons, NCN5390CGoebel Kendra S · Sarasota, FLN5390E402wd Holdings LLC · Robstown, TXN5390NLarsen Steve J · Colton, ORN5390QIgnarro Jessie · Bay Shore, NY
Back to AD 79-10-14 R1