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.
N7770UBrown Michael E · Miramar, FLN7771AWells Jason R · Chugiak, AKN7771BBeam Thomas W · Paw Paw, MIN7771EEchanove Michael · Palouse, WAN7771GEmpire Aero Club Inc · Sebastopol, CAN7771TBailey Bradley E · Phoenix, AZN7771UPryor Isaac L · Charlotte, NCN7772BLunken Martha F · Cincinnati, OHN7772FCushing Aviation LLC · Red Wing, MNN7772GWings Over Texas Holdings LLC · Denton, TXN7772UKiger Aviation LLC · Corvallis, ORN7772WWadhwa Anil Jethanand · Clarksville, TNN7772XPremier Air Inc · Raceland, LAN7773FDux Aaron T · Missoula, MTN7773TBennett Kevin S · Bay City, ORN7773UWitsberger Kelly R · Newburg, MON7774ASaydun LLC · Richardson, TXN7774BAdair Aviation LLC · Broken Arrow, OKN7774FMurphy Jeffrey R · Newport, MNN7774GElliott Miles · Porterville, CAN7775GMondragon Vidahk D · Reseda, CAFirst renewal noticeN7775KMarsh John E · Washington, DCN7775TSheaffer Hayden L · Lititz, PAN7776EOtte Bowdie · Norfolk, NEN7776GGulf Atlantic Airways Inc · Gainesville, FLN7776HAcevedo Adriel · San Antonio, TXN7776XVista I Inc · Smithville, OHN7777ALibby Stephen R Trustee · Anchorage, AKN7777CSouthern Sky LLC · Henderson, NVN7777SHood Company LLC · Nashville, TNN7778Carpenter Darrell W · Midland City, ALN7778UAngel Del Mar LLC · Park City, UTN7779AHendry Rickey W · Apple Springs, TXN7779FSmith Brian · Richmond, INN7779KSeventy Six Juliet LLC · Oakland, CAN777ADLeithead Bruce O · Stone Mountain, GAN777AHJarhead Aviation LLC · Port Saint Lucie, FLN777BMJet Air Of South Florida Inc · Deerfield Beach, FLN777CASwamp Skies LLC · North Miami, FLN777CFCp Aviation LLC · Pasco, WAN777DUSc Infinities LLC · Dover, DEN777FWLewis Kent · Lake Oswego, ORN777GTShillings Phillip J · Goldthwaite, TXN777HEUsoarflorida LLC · Fort Myers, FLN777HKPremiere Aviation LLC · Evansville, INN777HMMusser Harold R · Cody, WYN777HRLansing Skylane Inc · Orland Park, ILN777HSJohnson Erik L · Long Beach, CAN777JKGeoterra Inc · Eugene, ORN777KSBrahm Robert D · Mercer Island, WA
Back to AD 79-10-14 R1