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.
N8807GHague Ryder S · Bradfordsville, KYN8807UHarkins Robert W · Arnold, CAN8808SReber Scott D · Newcastle, UTN8808TGreissing John P · Aguila, AZN8808UValiair Limited Company Trustee · Casper, WYN8809BEagles Wings Inc · San Angelo, TXN8809SJednacz Scott T · Bixby, OKFirst renewal noticeN8809XParker James G Jr · Bellevue, NEN880AFAmeriflyers Of Texas Inc · Addison, TXN880CBJ-Airco LLC · Nashville, TNN880CKOlson Craig J · Bettendorf, IAN880CPCivil Air Patrol · Maxwell Afb, ALN880EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN880LSYoshitomi Chad M · Anchorage, AKN880MTKibler John · Kalispell, MTN880PMTimeless Flight LLC · Spanaway, WAN880THAviation Peter Corp Of New York · New York, NYN880WSDepartment Of Inland Fisheries And Wildlife · Greenville, MEN8810GSobers Dolton D A Jr · Caguas, PRN8810UWebesharing LLC · Orange Beach, ALN8810XLaughlin Robert L · Santa Ynez, CAN8811BMatty Elizabeth · Tucson, AZN8811UAlder William D III · Athens, OHN8811XSchwarzmann Bryce A · Falls Church, VAN8812Zzz Aviation LLC · Newberg, ORN8812SAnderson Benjamin J · Mondovi, WIN8812XOconnor Brian Edmond · Portland, ORN8813TBruno Samuel P · Missoula, MTN8813UAerios Air LLC · Midland, TXN8813XMeccanized LLC · Kalispell, MTN8813ZDuman Adrianna A · Los Angeles, CAN8814BEvans Roy L · Winnemucca, NVN8814TSchildberg Gregory M · Casey, IAN8814XCloudstreet Flying Services · Broomfield, CON8815BWiser Kurtis · Kennewick, WAN8815TWills Casey B · Gulf Shores, ALN8815ZAerowood Aviation LLC · Monroe, NCN8816UHocus Holdings LLC · Carrollton, OHN8817SRomeo Tango Aircraft Holding LLC · Merritt Island, FLN8817TTop Hand Inc · Laurel, MTN8817ZRegistration Pending · Redmond, WARegistration pendingN8818BFairfield Eugene D · Wiscasset, MEN8818TEngel Samina · San Diego, CAN8818UUfford Christian T · Vershire, VTN8819GGipson Aviation LLC · Winchester, TNN8819SSmith Cory M · Naples, FLN8819UBoss Gary W · Bronston, KYN881ACFly Twin Comanche LLC · Peoria, AZN881FDDaneco LLC · Houma, LAN881JFGriffin Aviation LLC · Minneapolis, MN
Back to AD 79-10-14 R1