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.
N7760GLeriche Nicolette · Oceanside, NYN7760UScott Timothy E · West Danville, VTN7761FSullivan Randall G · Liberty, TXN7761KGoldmark Peter J · Olympia, WAN7762EPierce Roger V · Broken Arrow, OKN7762FCosta Air Service LLC · Painted Post, NYN7762TLisle Rachel C · New Enterprise, PAN7762XRodriguez Bruno · Crestview, FLN7763CHudzinski Thomas E · Wasilla, AKN7763FRoss Joshua S · Homer, AKN7763TWood Pro Ventures LLC · Justiceburg, TXN7763UMarshall Michael S · Lincoln, CAN7764FAbouhatab Majed · Houston, TXN7764GTriad Aviation Academy LLC · Greensboro, NCN7764XMalcolm Ward A · Moorefield, WVN7765EFuellner Sean L · Shelocta, PAN7765FFilippone Chrristopher A · Ormond Beach, FLN7765GJefferies Stanley J · Coos Bay, ORN7765TWhisman Marc K · Long Beach, CAN7765UCentral Ohio Soaring Association Inc · Marion, OHN7766EArmitage Alexandra S · Nederland, CON7766FBuckman Bill · Lorenzo, TXN7766GAir Ally Asset Management LLC · Chisago City, MNN7766TGourley Steven E · Unionville, MON7767AWinged Bear LLC · Grafton, WIN7767BKline Paul · El Mirage, AZN7767EBruce Matthew · Arlington, TXN7767FMorris Donald R · Murphysboro, ILN7767GPerformance Aviation LLC · Fort Myers, FLN7767TVisscher Paul J · Madison, GAN7767USkynet Aviation LLC · Cocoa Beach, FLN7768AAmundson Scott E · Wrightwood, CAN7768EYounger David B · Port Angeles, WAN7768UFoothill Sport Aviation LLC · Cameron Park, CAN7769APliska Alan T · Torrance, CAN7769EFieldgrove Matt · Somerton, AZN7769TWhiskey Tango Foxtrot Aviation LLC · Bemidji, MNN776AASolo Aircraft Rental LLC · Farmingdale, NYN776CPCivil Air Patrol · Maxwell Afb, ALN776MWAlf Ix LLC · Chicago, ILN776NGoeken William K Trustee · Sanger, TXN776SASopwith Camel Flying Club LLC · Salt Lake City, UTN776SCJuliet Charlie Aviation LLC · Oregon City, ORN776TMAero Performance LLC · Scooba, MSN776VB40ac LLC · Hartford, WIN7770ASampson Zachary J · New Braunfels, TXN7770EDye John Donald Jr · Higginsville, MON7770GMyers Keith R Trustee · Fond Du Lac, WIN7770KAir Craft LLC · Sheridan, WYN7770TShinn William D · Milton, WA
Back to AD 79-10-14 R1