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.
N7226V226v LLC · Zachary, LAN7227ANewman Christan C · Niota, TNN7227GBeltz Richard D · Lehighton, PAN7227QElite Air LLC · Tullahoma, TNN72285Cave Creek Organics LLC · Flagstaff, AZN72288Roberts Matthew R · Idaho Falls, IDFirst renewal noticeN7228APaine Jered J · Cashmere, WAFirst renewal noticeN7228GFasking Dan · Stanford, ILN7228MBarton Chris · Bedford, WYN7228SMendoza William S · Antioch, CAN7228XBrown Richard D · Woodward, OKN72298Ronald D Mcgill Farms Inc · Klamath Falls, ORN7229ASale Reported · Belleville, ILSale reported, pending cancellationN7229ECreighton Richard L · Cincinnati, OHN7229QSwitzer Frank Jr · Port Allegany, PAN7229TSmith Carl L · Vinita, OKN722AARobinson Charles F Jr · Portage, MIN722BASunshine Airplanes LLC · Chandler, AZN722BCNordberg Chad J · Moses Lake, WAN722BSAnstrand Charles J · Boise, IDN722CPFalcon 118 Denver LLC · Tiburon, CAN722DMU S Wire Manufacturers Inc · Redwood City, CAN722EELipham William H · Odessa, TXN722EFEpic Aviation Inc · New Smyrna Beach, FLN722ELBristow Bryan M · Albany, ORN722HGAmeriflyers Of Florida LLC · Addison, TXN722JC722jc LLC · Tyler, TXN722LAllen Steven C · Crittenden, KYN722LULiberty University Inc · Lynchburg, VAN722MAK2 Aviation LLC · Greenwood Village, CON722PDW O Zangger And Son Inc · North Loup, NEN722RGTri Ag Supply Inc · Harvard, ILN722RRAncira Autos LLC · San Antonio, TXN722SAElmendorf Afb · Elmendorf Afb, AKN722SJJackson Stephen L · Belvidere, ILN722TMHenry John W · San Jose, CAN72306Usda Aphis Ppq · Edinburg, TXN72309Orion Works Ltd · Denali Park, AKN7230GMaples Kevin T · Pueblo, CON7230MSpring-Air LLC · De Graff, OHN7230QArcade Flying Club Inc · El Dorado Hills, CAN7230SMarsh John E · Washington, DCN72313Alaskan Air Charter LLC · Anchorage, AKN7231QDsr-Cherokee 180 LLC · Dallas, TXN7232ABakunova Eugenia S · Cordova, AKN7232ESitta Donald C · Farmington, NMN7232NT&A Farm LLC · Rifle, CON72337Gilbert Daniel Keith · Kodiak, AKN7233MGunderson David A · Box Elder, SDN7233SHeidelberg Haley · Huntington, TX
Back to AD 79-10-14 R1