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.
N6210FLichtman Aaron M · Baltimore, MDN6210GJm Pop LLC · Queen Creek, AZN62112Southern Sky Aviation LLC · Dover, TNN6211ASaulsberry Regor L · Datil, NMN6211BFleming Patrick J Trustee · Palm Desert, CAN6211DMcdonald Air Services LLC · Saint Johns, MIN6211KCalifornia Management And Consulting LLC · North Hollywood, CAN6211TPeterson Troy · Karlstad, MNN6212FParker Helicopter LLC · Watsonville, CAN6212GLionheart Aviation Services LLC · Fairfax, VAN6212RPliego M Guillermo M · Corpus Christi, TXN6212YHoran Jack F · De Berry, TXN6213AHerbert Ronald J · Anchorage, AKN6213EBeesley Charles F III · Cole Camp, MON62142Xin Han Aviation LLC · Atwater, CAN62144Intermill Glen M Trustee · Eagle Point, ORN6214ASkydive Cape Cod Inc · Caddo Mills, TXN6214KHamptonville Aviation LLC · Hamptonville, NCN6214SRex Douglas A · Marion, INN6214VRegistered aircraftN6215AC & B Aerial Transport Inc · Wilmington, DEN6215BArtskills Inc · Bethlehem, PAN6215EReinders Gary J · Orange City, IAN6215GSkagit Airport Eaa Chapter 818 · Shoreline, WAN6215SSmith Clifford W III · Exeter, CAN6216ASnow Terry R · Oak Harbor, WAN6216EPratt Joseph O · Wasilla, AKN6216RRegistered aircraftN6216STms Holdings LLC · Neenah, WIN6217ESchiffel Peter W · Pequannock, NJN6217KIoannou Yiannakis C · Wilmington, NCN6217NXing Kong Aviation Service LLC · Atwater, CAN6217QZulu Kilo LLC · Seven Valleys, PAN6217RCampbell J R Jr · Bell, FLN6217SKent J'Amy L · Chewelah, WAN6217TTaylor Nathan E · Spanishburg, WVN6218BBrant Air LLC · Davidsonville, MDN6218EZephyrhills Flying Club Inc · Tampa, FLN6218GGoatley Valerie M · Springfield, KYN6218RAnnala John H · Dacula, GAN6218YLucky Star Auto Sales Inc · Grangeville, IDN62195Aire Services LLC · Barrigada, GUN62199Aircraft Guaranty Corp Trustee · Oklahoma City, OKN6219EOaks Randall K · Oxnard, CAN6219FAircraft Rental Services LLC · Arlington, TNN6219KIrwin Michael C · North Fort Myers, FLN6219NMiles Media LLC · Red Lodge, MTN6219RRegistered aircraftN6219TCode4 Ventures Inc DBA · Waynesboro, VAN6219UHardy Jeffrey T · Ellsworth, ME
Back to AD 79-10-14 R1