AD 76-14-07 R2
Registered aircraft · 930
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-14-07-R2')
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-14-07-R2')
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-14-07-R2') 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-14-07-R2') 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.
N10007Insko Matthew T · Papillion, NEN100BMarshall Xavier T · Carson, CAN101PQValiair Limited Company Trustee · Casper, WYN1024Calgonaire LLC · Seminole, TXN102JJGrose Christopher E · San Antonio, TXN1071MJesperson Kenneth R · Ekalaka, MTN109HBadke Paul J · Ray, MIN10GMAlo Aviation LLC · Titusville, FLN10RVKoehn Shane Michael · Scooba, MSN111PWKilgore Eric M · Genoa, NVN119MSAeronorth LLC · Ann Arbor, MIN11LATwo-Ten LLC · Ramona, CAN122FSiver Creek Capital LLC · Emery, SDN123JTGraham Richard A · Wichita Falls, TXN123KTHolliday Paul B · Kiln, MSN123UAwg Aviation LLC · Ainsworth, IAN12RFMckay Jonathan S · Chesapeake, VAN12WDHamburg Jeffrey · Corsica, SDN1333TWoodford Michael F · Fabius, NYN13BJSevcik Clint · Medford, MNN141DMTurbo Inc · Flint, MIN1545GSaltzer Eric R · Somerton, AZN154BCTen Knot Tailwind LLC · Mesa, AZN154EFAdams Donald C · Garner, NCN155KTN155kt LLC · Dover, DEN157LMBaughman David · Jeffersonville, INN165WFHardin John M · Terrell, TXN169PGHarty Joshua · Strasburg, CON1717XSay Plastics Inc · Jacksonville, TXN1724THanna David B · Tonasket, WAN173MCCiochetti Michael J Jr · Clayton, GAN17ABBas Part Sales LLC · Greeley, CON17HSRed Oak Centurion LLC · Red Oak, IAN17JYYorkavitz James B · Valley City, OHN17TCKenyon Walter C · Eureka Springs, ARN1800FReid Brian M · Boise, IDN1802FSantiago Ferdinand · Calhoun, GAN1804FWaage Todd · Greenbush, MNN1814FAlpine Cable And Construction Inc · Grand Junction, CON1816FMalcom Scott O · Toledo, WAN1821FAlexander Travis · Hudson Oaks, TXN1828FDrew Kevin · Fredonia, PAN1833FHale Jay · Corpus Christi, TXN1839FHentz Randy Reuben · Tower City, PAN1843FJordan Jay · Centre, ALN1845FJones Sandy Ray · Williamsburg, NMN1849FCrouse William F · Priest River, IDN1852FSymbot Management Inc · Dover, DENon-citizen corporation, flight hours not reportedN1854FHarlan Bradley J · New Brighton, MNN1859FBaker Robert J · Ogema, MN
Back to AD 76-14-07 R2