AD 76-16-07
Registered aircraft · 467
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:76-16-07')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-16-07')
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:76-16-07') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-16-07') 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.
N200MCN200mc Inc Trustee · Cheyenne, WYN205CAHyannis Air Service Inc DBA · Hyannis, MAN216LBBail Air LLC · Port Saint Lucie, FLN222AXGraven Timothy G · Foristell, MON222BJFlight Smith LLC · Orem, UTN222PRFlying South LLC · Wilmington, DEN222RMKelco LLC · Helena, MTN222SVEllsworth Jason W · Hamilton, MTN223PBHyannis Air Service Inc · Hyannis, MAN2293FTwo Mile High Mining LLC · Victor, CON22NRJefferson Aviation LLC · Seville, OHN231JPQuest Air Inc · Cocoa, FLN236ATN236at LLC · Miami, FLN236STOutdoor Metal Products LLC · Leighton, ALN239ELDingman Marine LLC · Orlando, FLN246BEOn Top Aviation LLC · North Las Vegas, NVN247GSHyannis Air Service Inc DBA · Hyannis, MAN256CAHyannis Air Service Inc · Hyannis, MAN258PBHyannis Air Service Inc · Hyannis, MAN2610GBas Part Sales LLC · Greeley, CON2611XHyannis Air Service Inc DBA · Hyannis, MAN2614LCharter Flights Caribbean Inc · San Juan, PRN26156Hyannis Air Service Inc · Hyannis, MAN2615GHyannis Air Service Inc DBA · Hyannis, MAN2615QVenture Air Solutions Inc · Opa Locka, FLN2649ZHyannis Air Service Inc · Hyannis, MAN26514Hyannis Air Service Inc · Hyannis, MAN2651SHyannis Air Service Inc · Hyannis, MAN267CAHyannis Air Service Inc DBA · Hyannis, MAN2694HRockingham Carriage Services Inc · Greenland, NHN26STSky Condor Aviation LLC · Flatwoods, WVN270RCEagle 1-N270rc LLC · San Juan, PRN2712FDodson International Parts Inc · Rantoul, KSN2715TDelaware Aircraft Trust LLC Trustee · New Castle, DEN2718YRichland Aviation Inc · Sidney, MTN274MRAero Systems Inc · Broomfield, CON275RCGianopoulous William · Lawrence, MAFirst renewal noticeN277XSalopek Rett · Las Cruces, NMN290CAHyannis Air Service Inc · Hyannis, MAN2JJAerial Surveys International LLC · Watkins, CON300FDGondola Investments LLC · Miami, FLN303DCRegistered aircraftN30DTShelton Sharon Shay · Abilene, TXN30SSN30ss LLC · Dover, DEN3131KAmazon Aero Corp · Wilmington, DEN313RWSarp Rentals LLC · Loudon, TNN31AWRestoration Dental · Chesterfield, MON31RTPapuchin LLC · Highwood, ILN320PCAom Aircraft LLC · Wilmington, DEN321HDodson International Parts Inc · Rantoul, KS
Back to AD 76-16-07