Skip to content

Registered aircraft · 1,309

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:94-18-04-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:94-18-04-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:94-18-04-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:94-18-04-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:94-18-04-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:94-18-04-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.

N103DBZelasko Edward P · Oxford, WIS/N A-86 N105VCBrewer Curtis E · Garland, TXBuilt 1946 · S/N 2534 N113WMStarke Charles H III · Weirsdale, FLBuilt 1966 · S/N A-114 N1210HThiel Scott D · Edgewood, WABuilt 1946 · S/N 3887 N121VVBowers Airplanes LLC · Chesterfield, VABuilt 1946 · S/N 3440 N123YPLeochner Jason F · Decatur, TXBuilt 1947 · S/N 4503 N127GBaine Larry A · Marne, MIBuilt 1963 · S/N 4795 N13PQAllen Ron · Oceanside, CABuilt 1946 · S/N 3544 N142Rains Cecil R · Wichita, KSBuilt 1940 · S/N 12 N153JDMorgan Thomas R · San Antonio, TXBuilt 1946 · S/N 284 N15AVRoquemore William A Jr · Lakeland, GABuilt 1966 · S/N A-154 N15JLTravland Lewis H · Alpine, TXS/N 2410 N1611Hibler Kenith R · Newcastle, OKBuilt 1946 · S/N 1537 N161LHJackson Donald R · Lexington Park, MDBuilt 1966 · S/N A161 N1659ZSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1949 · S/N 5021 N168PMcmanus Brian K · Smithville, TXBuilt 1946 · S/N 905 N169WSMarcoux George Alfred Jr · Shapleigh, MEBuilt 1946 · S/N 856 N179GAnderson John P · Knoxville, TNBuilt 1946 · S/N 1802 N17JDSpecht Leo M · Towner, COS/N 4354 N18064Heath Aircraft LLC · Portland, ORBuilt 1938 · S/N G-2 N18443Williams David R Jr · Bellevue, WABuilt 1938 · S/N G-6 N190XAirline Pilots Historical Society · Saint Charles, ILBuilt 1946 · S/N 2445 N194HSFuller Randy M · Mooresville, NCS/N 1517 N1GUHabbal Wissam · Rosamond, CABuilt 1957 · S/N 5610 N1NYTech Mobile LLC · New Windsor, MDBuilt 1946 · S/N 1674 N1YYFlying Low Racing LLC · Oklahoma City, OKBuilt 1956 · S/N 5602 N2005HLaslo Lawson P · Oklahoma City, OKBuilt 1946 · S/N 2628 N2007HElder Robert C · Prosser, WABuilt 1946 · S/N 2630 N2013TSamford Tristan W · Carthage, TXBuilt 1946 · S/N 2689 N2021HGregory Vernon L · Swansea, SCBuilt 1946 · S/N 2644 N2022HGartke Michael L · Waterman, ILBuilt 1946 · S/N 2645 N2024HVarzavand Shahram · Cedar Falls, IABuilt 1946 · S/N 2647 N2034HWustrack Jeffrey F · Wichita, KSS/N 2657 N2038HOgren Michael W · Spring Hill, FLBuilt 1946 · S/N 2661 N2050HCopaair Maintenance Services Inc · Indiantown, FLBuilt 1946 · S/N 2673 N2064HMcbride Devin · Forney, TXS/N 2687 N2065HAnderson Nancy L · Chehalis, WAS/N 2688 N2070HFike Glen P · Beavercreek, OHBuilt 1946 · S/N 2693 N2077HWinter Jack W · Custer, SDBuilt 1946 · S/N 2700 N2078H84 Aviation Llp · Lebanon, OHBuilt 1946 · S/N 2701 N2078SVolkman Royce D · Fairview, MTS/N 1428 N2081HGutierrez Ryan Y · Pacoima, CABuilt 1946 · S/N 2704 N2083HHatcher Joe W · Ripon, WIBuilt 1946 · S/N 2706 N2095HStovall Spencer R · Iuka, MSBuilt 1946 · S/N 2718 N20990Willis William P Trustee · New Palestine, INS/N 8 N20991Perry Aaron O · Piqua, OHBuilt 1938 · S/N G9 N20993Western Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1938 · S/N G-11 N20996Parsons Lee E · Carrollton, OHBuilt 1938 · S/N G-14 N2102HHarvell Randall W · Manteno, ILS/N 2725 N2118FMclaughlin Michael W · Egg Hbr Twp, NJBuilt 1946 · S/N 2102

Back to AD 94-18-04 R1