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.
N8111XPhillips Zachary T · Kettering, OHN8111ZSchmitts Air Inc · Enumclaw, WAN8112UHaleco LLC · Pensacola, FLN8112XPeterson Michael D · New Richmond, WIN8112ZTobias Aaron C · Clearwater, KSN8113AEllis Jeffrey C · Davis, ILN8113FBrundige Kevin J · Bennington, VTN8113LN8113l LLC · Auburn, INN8114BAllan Bryan S · Sandy Valley, NVN8114SSutton Richard C · West Lafayette, INN8115EGrillos Emmanuel John II · Kent, WAN8115SRoberts Earl C · Mobile, ALN8115TGuarno Adam C · Jacksonville, FLN8116FOmlid Robert L · Watford City, NDN8116GJrb12 Inc · Shorewood, ILN8116TBliss Kirk R · Maize, KSN8116ZJohnston Joshua R · Scappoose, ORN8117AJago River Holdings LLC · Fairbanks, AKN8117FHhd Aviation LLC · Hamilton, OHN8118BBarrera Daniel J · Sugar Land, TXN8118FMiller Christa L · Rhodesdale, MDN8118URegistration Pending · Heath, OHRegistration pendingN8119AHuling Lawrence K · Wasilla, AKN8119TLarson Larry L · Gackle, NDN8119URosenoff John D · Riverside, WAN811AFState Of Louisiana · Baton Rouge, LAN811AHOtv Leasing · Manassas, VAN811BJSix Pack Aviation LLC · Pocono Pines, PAN811CAChristiansen Aviation LLC · Wilmington, DEN811CPCivil Air Patrol · Maxwell Afb, ALN811CTBravo Aircraft LLC · Ooltewah, TNN811CXRegistration Pending · Brentwood, CARegistration pending, pending cancellationN811ECChin-Loy Christopher Wayne Trustee · Tamarac, FLN811EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN811GMEldredge David A · Snohomish, WAN811GWGreat Western Aviation Leasing LLC · Ogden, UTN811HATate Grady · Harrisburg, NCN811JDSanders Jason C · Babylon, NYN811KSFargo Jet Center LLC · Fargo, NDN811LTegtmeier Michael C · Watertown, WIN811LLLa Vida Aviation LLC · Lake Bluff, ILN811TWNova Aircraft Holdings Inc · San Diego, CAN811XArkoma Aviation LLC · Henryetta, OKN8120AGladden David G · Wasilla, AKN8120TJordan Francis E · Hillsboro, WIN8120UTeague Phillip · Lanett, ALN8120ZMechelay Joseph J · Pampa, TXN8121GTwo One Golf Ltd · Waterloo, IAN8121UFishburn Tol M · Eagle River, AKN8121VValley Paul D · Lakeville, MN
Back to AD 79-10-14 R1