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.
N7959TArrow LLC · Pateros, WAN7959UShugart Tiffany C · Canfield, OHN795FAAb Prop Plane II LLC · Metairie, LAN795THOcean Aviation Inc · Georgetown, DEN7960BHolte Martin W · Burnsville, MNN7960THayden James R · West Fargo, NDN7961BGmitter Joseph J · Forest Lake, MNN7961GAlternate Air Inc · Seattle, WAN7961TBoardman Thomas M · Greenwich, NYN7961XCarruth Sam · Ripon, CAN7961ZBoho LLC · Lewes, DEN7962BHall Jason J · Moses Lake, WAN7962ENesta Alex · Winder, GAN7962FFlying Colors Airparts Inc · Leesburg, FLN7962GR House Leasing LLC · Stormville, NYN7963BPerkins C Trent Blaise · Wonder Lake, ILN7963GAvian Leasing LLC · Bremerton, WAN7963TSawyers Susan J · Tazewell, VAN7963UKischnick Brett A · Lapeer, MIN7963XHairetown LLC · Johnson City, TNN7964VNorris John R · Anchorage, AKN7964XEdwards Jerry T · Palo Pinto, TXN7965ELangton Kathy A · Exeter, CAN7965ZElliott Frank F · Mojave, CAN7966BBrashar Kevin · Anchorage, AKN7966UPatterson Robert E Trustee · Petaluma, CAN7967BScholz Alan A · Rosamond, CAN7967GWings Over Texas Holdings LLC · Denton, TXN7967TMachowicz Mark M · Eastpointe, MIN7967XSchneider David L · Saginaw, MIN7967ZBreckenridge Steven C · Farmington, ILN7968BWaltz Patrick T · Delanson, NYN7968FFlyin Cowboys · Manning, NDN7968TSiegel Donald S · Northampton, MAN7969BConnolly Patrick J · Skaneateles, NYN7969GHealsburg Aviation · Healdsburg, CAN7969JPegasus Air Ventures LLC · Macedon, NYN7969XBurnham Bros · Winner, SDN796EPPrince Ellis C · Frierson, LAN796HAJatavallabhula Narasimha Sastry · Longview, TXN796SPOpensky Airways LLC · Los Angeles, CAN796THSanders Flight Training Center Inc · Jasper, ALN796WTTaildragger LLC · Blackfoot, IDN796WWCrist Aviation Services LLC · Woodland, CAN7970EMckenna Terence M · Scotts Valley, CAN7970FConnor Christopher Donnie · Chicago, ILN7970GAmerican Patrols Inc · Midland, TXN7970UChard Robert L · Byron Center, MIN7971BKimberling David L · Lincoln City, ORN7971FJanes Christopher D · Columbia, KY
Back to AD 79-10-14 R1