Skip to content

Registered aircraft · 4,001

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-13-10-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-13-10-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-13-10-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-13-10-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-13-10-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-13-10-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.

N5426SPetrof Karl J · Ligonier, PAS/N 337-0526 N5428SLepping Kurt · Wasilla, AKS/N 337-0528 N542ADJohnson Thomas F · Buckeye, AZS/N R1720234 N542DFFretwell David H · Paso Robles, CABuilt 2004 · S/N LS-218 N5431SGreensburg Jeanette Airport Administration Inc · Jeannette, PABuilt 1966 · S/N 337-0531 N5446SDelgado Alvaro A · Orange, VABuilt 1966 · S/N 337-0546 N5451SDodson William G · Quebeck, TNBuilt 1966 · S/N 337-0551 N5453VTim Whitfield Aviation Inc · Farfield, NCBuilt 1977 · S/N R1722299 N5456SWood Charles G Trustee · Amarillo, TXBuilt 1967 · S/N 337-0556 N5460SMatanane Roke C · Barrigada, GUBuilt 1966 · S/N 337-0560 N5463FHudson Wilburn Joel · Rocky Face, GABuilt 1976 · S/N 34-7770022 N5463SPlanzer Henry L · Dalton, GABuilt 1966 · S/N 337-0563 N5475SGillies Paul A · Grapevine, TXBuilt 1966 · S/N 337-0575 N5477SChickasha Wings Inc · Chickasha, OKBuilt 1966 · S/N 337-0577 N5478SPoppima Photonix · Granbury, TXBuilt 1966 · S/N 337-0578 N5487SRobbins Phillip W · Maryville, TNBuilt 1966 · S/N 337-0587 N548CDEzcow LLC · Bedford, MABuilt 2005 · S/N 1582 N548JMLarock Guy · New Bedford, MABuilt 1979 · S/N 28R7931018 N54EPortland Community College · Portland, ORBuilt 1973 · S/N P3370156 N54ERKhandpur Rajiv K · Hicksville, NYBuilt 1982 · S/N 24-1305 N54JRBlock John R · Pittsburgh, PABuilt 1977 · S/N P3370278 N54PHAdvanced Design & Analysis Inc · Las Vegas, NVBuilt 1978 · S/N 34-7870233 N54UTCanning Steven T · Orange, MABuilt 1977 · S/N 34-7770302 N550JGNorby Aviation LLC · Hopkinton, MABuilt 2001 · S/N 1161 N550STWilliston Basin Energy LLC · Bismarck, NDBuilt 1985 · S/N 348533008 N551Historic Aircraft Restoration Museum · Saint Louis, MOBuilt 1954 · S/N 216 N551DKTarrow Group LLC · Thompsons Station, TNBuilt 1978 · S/N 28R-7803279 N553DMEuro2000 Inc · Merritt Island, FLNon-citizen corporation, flight hours not reportedBuilt 1976 · S/N 34-7670330 N5544MSchar Aviation LLC · Dallas, TXBuilt 2003 · S/N 1335 N555BTPeters Andrew Thomas · Annandale, MNS/N 34-8233014 N555DRRasor David N · Spokane, WAS/N DR-1 N555KCBashir Atlantic LLC · Wilmington, DEBuilt 2004 · S/N 1438 N555LFrankland Robert · Jackson, TNS/N 34-7970489 N555TCArchibeque Christopher James · Albuquerque, NMBuilt 1977 · S/N 28R-7703061 N555UJAero Holdings LLC · Palm City, FLBuilt 1984 · S/N 348433039 N555WMWest Warren K · Raymore, MOBuilt 1979 · S/N 28-7921047 N5561VPm Aviation Services LLC · Kailua, HIBuilt 1977 · S/N 34-7770253 N5566Tenney Jennifer L · Orange, MABuilt 1969 · S/N 276 N556CLLutz Ed · Pine Valley, CABuilt 1966 · S/N 337-0543 N558CMWells Airways LLC · Austin, TXBuilt 1978 · S/N 34-7870290 N558SWProtec Proz LLC · Ball Ground, GABuilt 2005 · S/N 1504 N55BVVerran Robert W · Michigan City, INBuilt 1995 · S/N 55BV2SA1 N55CKDobson Billy M · Tichnor, ARS/N R1722409 N55CSHammond Neil K · Manhattan, KSBuilt 1965 · S/N 337-0222 N55DSN55ds LLC · Saint Paris, OHBuilt 1999 · S/N 1010 N55PEVenusti James J · Mahwah, NJS/N 25-1156 N560Carter Brooks LLC · Kalispell, MTBuilt 1979 · S/N P3370330 N5612WNelson Kenneth G · Holly Ridge, NCBuilt 1983 · S/N 25-0732 N5614JAltair Aircraft LLC · Gainesville, FLBuilt 1983 · S/N 25-0733 N5620ZCloudtop LLC · Rockport, INS/N 25-0735

Back to AD 81-13-10 R1