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.
N8104MMakati 121 LLC · Las Vegas, NVN8104SFlowers Tony C · Panhandle, TXN8104TBrewer Lance A · King Salmon, AKN8104UMellen Dennis L · Peoria, ILN8104ZNegris James R · Mazama, WAN8105LIowa Skyhawk LLC · Charles City, IAN8105MSudworks Aviation LLC · Ardmore, OKN8105TButcher Nicholas R · Litchfield Park, AZN8106FHoward Mason · Phoenix, AZN8106SMay Jason L · Alva, OKN8106XJones Wayne D · Huron, SDN8106ZWilliamson Gary S · Lakeport, CAN8107AE=Mc2 LLC · Prescott Valley, AZN8107LConrad Adam C Jr · Duncansville, PAN8107SChalmers Ashley · Manalapan, NJN8107ZReid Brian M · Boise, IDN8108ACraig Benjamin C · Wasilla, AKN8108FSale Reported · Greenback, TNSale reportedN8108SGray Ronald W · Hooker, OKN8108TEarly Robert A · White Oak, TXN8108UTimko Jacob E · Levittown, PAN8108XReding Joel M · Whittemore, IAN8109AWatkins Brian · Bowling Green, KYN8109LVajgrt Richard Eugene · Mobile, ALN8109SWillis Quinton Blair · Murfreesboro, TNN8109TStoots David A · Fairbanks, AKN8109UShisler James E · Oakwood, OHN810CAChristiansen Aviation LLC · Wilmington, DEN810CLMathews Roy E · Sparta, MIN810CPCivil Air Patrol · Maxwell Afb, ALN810EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN810FSModi Yogini · Homestead, FLN810JLFly Cessna LLC · Peoria, AZN810JVCarstensen Ross J · Waterloo, NEN810KKKenzy 2023 LLC · Aurora, ORN810KSFargo Jet Center LLC · Fargo, NDN810KTDavis John M · Fairhope, ALN810MFTorroija Matias · Miami, FLN810RFQuiring Mark Edmond · Mount Pleasant, TXN810SABlack Hound Aviation LLC · Austin, TXN810SUApm Leasing LLC · Casper, WYN810WSky-Pirates LLC · Deland, FLN8110LMiller Brian T · Savage, MNN8110SV B Aviation LLC · Peachtree City, GAN8110UHeigle Randall K · Fouke, ARN8110VN8110v LLC · Havana, FLN8111BTaylor Brad · Alma, GAN8111SDavis Ronald K · Havelock, NCN8111TRoy David J Sr · Summerland Key, FLN8111UTarkki Jarmo O · Solvang, CA
Back to AD 79-10-14 R1