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.
N86SSAerobanc Of America Inc · Camarillo, CAN86VBAce Flight Center · St Thomas, VIN86WAWyatt David M · Kennewick, WAN86WEBlue Air 1 LLC · Homestead, FLN8700BWall Bernardo · Seminole, TXN8700XOdonnell Daniel V · Dover, DEN8700ZBergh Gene H · Roberts, WIN8701SRoth David A · Milford, NEN8701XThree Green Enterprises LLC · Redondo Beach, CAN8702BHill Thomas Gerald · Port Tobacco, MDN8702GHaney James H · Brooksville, FLN8702TWarner Billie J · Fair Oaks Ranch, TXN8702ZSutton Aircraft Salvage LLC · Palmer, AKN8703UNea Construction LLC · Jonesboro, ARN8703XFlying LLC · Kennewick, WAN8703ZLynch Cody Ryan · Galveston, TXN87045Newton Greg R · Powell, WYN8704XJohnson Hill A · Euless, TXN8704ZHunt David H · Ortonville, MIN8705BCarney David M · Mc Allister, MTN8705GHammond Douglas C · Des Moines, IAN8706BCox Robert D · Caldwell, IDN8706SN8706s LLC · Lake Orion, MIN8706ZElliott Michael L · Raeford, NCN8707BEmblom Donald B · Hackensack, MNN8707XTevis David J · Colorado Springs, CON8708SHall Tyler D · Citrus Heights, CAN8708UDewey William H Trustee · Eugene, ORN8708XSkylane Flyers LLC · West Jordan, UTN8709BBaldwin Steve · Lawson, MON8709UWilkinson James Richard · Carlsbad, NMN8709XWalton T Michael · Hudson Falls, NYN870CPAvolant Aviation LLC · Mooresville, NCN870EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN870PLake Elysian Sky Holdings LLC · Janesville, MNN870PDWings Over West Michigan Inc · Wyoming, MIN870SPEstern Kentucky University · Richmond, KYN870TWSouthern Haulers LLC · Leachville, ARN8710QMicro Tool Inc · Idaho Falls, IDFirst renewal noticeN8710SKressin Ray H · Waunakee, WIN8710TWilson Kendal · Carrizozo, NMN8710UDmac Aircraft LLC · Savannah, GAN8710XDiego Nicholas · Petaluma, CAN8710ZBurnham Kenneth J · Carr, CON8711BHubert Gregory D · Charles Town, WVN8711GBonno Douglas L · Iron River, MIN8711TFlyabq Aviation LLC · Bella Vista, ARN8711XAbidance Inc · Winthrop, WAN8711ZNeff John Sr · Lumberton, TXN8712SMarys Airport Acres LLC · Neenah, WI
Back to AD 79-10-14 R1