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.
N92788Bas Part Sales LLC · Greeley, CON92789N5746u LLC · Dover, DEN9278AHanna Mark W II · Pendleton, INN9279XKhoury Alain W · Wills Point, TXN927AZN927az LLC · Miami, FLN927CPCivil Air Patrol · Maxwell Afb, ALN927GHB R S Leasing Inc · Wilmington, DEN927GPChristiansen Aviation LLC · Wilmington, DEN927NBlue Sky Business Services Inc · Gardiner, NYN927TCWings Over Texas Holdings LLC · Denton, TXN927TSM & G Aircraft Management LLC · Aurora, ORN9280BDreessen Steven C · Walkerton, INN9280MRiley Dean A · Friday Harbor, WAN9280TChristiansen Aviation LLC · Wilmington, DEN92810Dilse Brian R · Grand Forks, NDN92814Kimbrell Tod L Jr · Itasca, TXN92815Halver Todd L Trustee · Advance, NCN92816Van Cleve G Steven · Windermere, FLN92817Millner James W Sr · Soldotna, AKN9281ABuiqui Aerospace Corp · Kissimmee, FLN9281GRuffner Scott A · Luray, VAN9281UOtters Heinrich · Fredericksburg, TXN92822Roada Inc · Indio, CAN92824C182 Wv LLC · Charleston, WVN9282AWest Sheryl M · Champlin, MNN9282TCloud 9 Aviators LLC · Anchorage, AKN9282USchur David · Lavernia, TXN92836Clark Wyatt · Ione, CAN92837Staszak Sandra · Martinsville, ILN9283AFf22 LLC · Scottsdale, AZN9283CFoerschler Dale · North Aurora, ILN9283GTexas Forever LLC · Denver, CON9283RAllied Sprayers Inc · Hawley, TXN92843Roehl John F Jr · Neapolis, OHN92844Smooth Sailing Flying Club Inc · Avon, INN92845Hainet Aero LLC · Wilmington, DEN92846Evans Millard D · Mobile, ALN9284BBeckley Larry · Scottsburg, INN92850Nelson Tabor K · Corona, CAN92855Falcon Flying Club · Mesa, AZN9285HOrion Aviation Aircraft LLC · Carlsbad, CAN9285XBlu Kaya LLC · Austin, TXN92866Green Edward L · Chico, TXN9286ASimon Theodore E · Richmond, MIN9286BHall Leslie E · Lubbock, TXN9286CQueen City Flying LLC · Helena, MTN9286RWiebe Aerial Applications LLC · Peabody, KSN9286XRogne Fred A · Fallon, NVN92873Sonday Terrance P · Spring, TXN92878Jackson Richard L · Indianapolis, IN
Back to AD 79-10-14 R1