Skip to content

Registered aircraft · 733

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

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:81-07-11-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:81-07-11-R1') ORDER BY n_number

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:81-07-11-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:81-07-11-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:81-07-11-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:81-07-11-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.

N188SRRogers Steven Trustee · Ogden, UTBuilt 1978 · S/N 340A0636 N1894EDelvest LLC · Grosse Pointe, MIBuilt 1979 · S/N 340A0662 N18MRMorey Airplane Co Inc · Middleton, WIBuilt 1978 · S/N 340A0557 N1905ERusso Louis A Jr · Houston, TXBuilt 1979 · S/N 340A0664 N1918EGuano Air LLC · Palmetto Bay, FLBuilt 1979 · S/N 340A0668 N1920EHappy Trails Flight Training & Charters LLC · Helena, MTBuilt 1979 · S/N 340A0669 N1944EHans Construction LLC · Lititz, PAS/N 340A0675 N2002PGregory Edward · Council Bluffs, IABuilt 1979 · S/N 335-0022 N200GCDancy Abram P · Shrewsbury, MABuilt 1978 · S/N 340A0503 N200YCShady Aero LLC · Anchorage, KYS/N 340A0285 N204KMInternational Air Services Inc Trustee · Carson City, NVS/N 340-0070 N20JNGana Trucking & Excavating Inc · Martell, NES/N 340A0050 N211SVMatthews Aviation LLC · Greensboro, NCS/N 340A1000 N21234Positive Rate LLC · Kenosha, WIBuilt 1982 · S/N 340A1207 N215CBKw Bradley Associates LLC · Manlius, NYBuilt 1980 · S/N 340A1019 N218CFLevel 200 LLC · Charlottesville, VABuilt 1980 · S/N 340A0989 N222RDAviation Consultants Inc · San Luis Obispo, CABuilt 1977 · S/N 340A-0366 N234MSVertical Horizon Aviation LLC · Sandown, NHBuilt 1975 · S/N 3400351 N234PSTkn Holdings LLC · Pima, AZBuilt 1977 · S/N 340A0368 N242GDodson International Parts Inc · Rantoul, KSS/N 340A0799 N242KABig River Air LLC · Jackson, MSBuilt 1983 · S/N 340A1802 N246JWPierson Janice R Trustee · Scio, ORBuilt 1981 · S/N 340A1253 N246KAStahl Richard J · Gainesville, TXBuilt 1984 · S/N 340A1817 N24CFAmerica Aviation LLC · Yuma, AZBuilt 1979 · S/N 340A0659 N252SLone Peak Air LLC · Gillette, WYBuilt 1980 · S/N 340A0984 N254PBNicole Business Group LLC · Hooks, TXBuilt 1982 · S/N 340A1504 N25EBLeisurecorp Inc · Anchorage, AKBuilt 1976 · S/N 340A0043 N25RFMlf Aviation LLC · Douglasville, GABuilt 1973 · S/N 340-0307 N25TAJms Properties Inc · Hudsonville, MIBuilt 1982 · S/N 340A1538 N265PCSilver Eagle II LLC · Carson City, NVBuilt 1980 · S/N 340A-0996 N2666DDrda Enterprises LLC · Denver, COS/N 340A0717 N2666JA-Leasing · Dayton, OHS/N 340A0718 N2669NWilliamson Benjamin J · Morgan Hill, CABuilt 1979 · S/N 340A0735 N2673DAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1979 · S/N 340A0755 N2676BKero Jet Corporation · Montgomery, TXBuilt 1979 · S/N 340A0762 N2676RStauter Michael D · Idabel, OKBuilt 1979 · S/N 340A0765 N2696HSunwest Aviation Inc · Santa Ynez, CABuilt 1979 · S/N 340A0778 N2696PBlue Wing Aviation LLC · Tulsa, OKBuilt 1979 · S/N 340A0779 N2696UBlack Dragon Consulting LLC · Phoenix, AZS/N 340A0780 N2699DN2699d Corp Trustee · Wilmington, DEBuilt 1979 · S/N 340A0787 N269PCSch Aviation Inc Trustee · SporleBuilt 1979 · S/N 340A0785 N269WTWillis James A · South Jordan, UTBuilt 1972 · S/N 340-0104 N2700YEaton Air LLC · Spearfish, SDS/N 340A0793 N2702VAtx Aero LLC · Austin, TXBuilt 1979 · S/N 340A0904 N2704NKimberton Corp LLC · Phoenixville, PABuilt 1979 · S/N 335-0003 N2704UMatheson Thomas Blair · Mandan, NDS/N 335-0005 N2705LLt Aviation LLC · Plattsmouth, NEBuilt 1979 · S/N 335-0010 N2706AFlhs LLC · Cedar Park, TXBuilt 1979 · S/N 335-0013 N2706TDodson Internarional Parts Inc · Rantoul, KSBuilt 1979 · S/N 335-0017 N2708SQuiroga Herman R · Phoenix, AZBuilt 1979 · S/N 335-0032

Back to AD 81-07-11 R1