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.
N5200ABarr Air Patrol LLC · Mesquite, TXN5200EViaene Tajae L · Fargo, NDFirst renewal noticeN5200HIowa Lakes Community College · Estherville, IAN5200QBas Part Sales LLC · Greeley, CON5200XRwr Air Inc · Tok, AKN52010Bentley John R · Bend, ORN52012Skylens LLC · Hammond, LAN52013Hillsboro Aero Academy LLC · Hillsboro, ORN52015Gibbs Timothy L · Valley Grande, ALN52016Lil' Dawg Aviation Inc · Oxford, MSN52017Worringer Richard G · Tower, MNN52019Bryant Robert D · Perry, UTN5201ADan Howard Aircraft Sales LLC · Tulsa, OKN5201EGholizadehkasgari Mary Ambanoo · Jacksonville, FLN5201HGorge Winds Aviation Inc · Fairview, ORN5201QAdams Clive P · Hendersonville, TNN5201RWest Florida Flying Service LLC · Safety Harbor, FLN52026Moore Enterprises Leasing Inc · Indianapolis, INN5202EMcdowell William R · Corpus Christi, TXN5202FUnited States Air Force (Owner) · Millington, TNN5202JLizco Aviation LLC · Jackson, MON5202NNorthern Aviation LLC · Palmer, AKN5202QRosso Matthew J · Mancos, CON5202RHahn Douglas Keith · Waldport, ORN52032Briner John T · Celina, TXN52034Arq Aviation LLC · Wilmington, NCN52035Chancellor J W · Brooksville, MSN5203AGv Air Inc · Medford, ORN5203DAcumen Aerotech LLC · Rogers, TXN5203FDale County Sheriffs Office · Ozark, ALN5203NNoam Eli · New York, NYN5203QMatteis Vincent M · Lyndonville, VTN5203RGehman David W · Atmore, ALN5203UHusted Robert P · Byers, CON5203XMike & Critter LLC · Mccall, IDN52044Peck John E · Everett, WAN52046C10 Fire Aircraft Holding LLC · Sunriver, ORN52048Time Flyers LLC · East Troy, WIN5204ECivil Air Patrol Inc · Maxwell Afb, ALN5204FUnited States Air Force · Offutt Afb, NEN5204NN5204n LLC · Palm City, FLN5204QWarren County Career Center · Lebanon, OHN5204VNimier Alexander M · Chatsworth, CAN52050Brown Thomas A · Lake Stevens, WAN52051Cutsforth Gary L · Palmer, AKN52055Schley James R · Palmer, AKN52057Redstone Arsenal Flying Activity · Redstone Arsenal, ALN5205DAlleghany Flying Club Inc · Hyndman, PAN5205EGates Stephanie E · Sutton, AKN5205RValley Pilots Flying Club Inc · Martinez, CA
Back to AD 79-10-14 R1