Skip to content

Registered aircraft · 26,232

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-05-05-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-05-05-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-05-05-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-05-05-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-05-05-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-05-05-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.

N72944Dirigo Aerospace Solutions LLC · Sumner, MEBuilt 1946 · S/N 10142 N72949Uhlemeyer William A · Alvin, TXBuilt 1946 · S/N 10147 N7294APiston Aviation LLC · Saint Charles, MOBuilt 1956 · S/N 29394 N7294TBurnett Albert Franklin · Lubbock, TXS/N 46894 N72950El Coyote Ranch LLC · Alzada, MTS/N 10148 N72951Ciholas Philippe A · Sedgwick, KSBuilt 1946 · S/N 10149 N72957Hugie Lucas R · Logan, UTBuilt 1946 · S/N 10155 N72959Holloway Kevin R · Williamsport, MDFirst renewal noticeBuilt 1946 · S/N 10157 N7295MLambert James · Fort Mohave, AZBuilt 1958 · S/N 55595 N7295SSpeedbird Ventures LLC · Driftwood, TXS/N 15067995 N72962Huff Tony D · Luthersville, GABuilt 1946 · S/N 10160 N72963Minier Tryg R · Watsonville, CABuilt 1946 · S/N 10161 N72966Capdepon Paul V · Newellton, LABuilt 1946 · S/N 10167 N7296AStoup Lyndal K · Cordell, OKBuilt 1956 · S/N 29396 N7296TTurner Clinton C · Springdale, ARBuilt 1959 · S/N 46896 N72971Hammerle Tye F · Kenosha, WIBuilt 1946 · S/N 10172 N72976Los Pajaros Flying Club Inc · El Macero, CABuilt 1946 · S/N 10177 N72977Parish Gary R · Olive Branch, MSS/N 10178 N72979Pyne Jeffrey S · Spanish Fork, UTBuilt 1946 · S/N 10180 N7297AMyers Maxwell D · Salt Lake City, UTS/N 29397 N7297DMachida Steven · Homer, AKBuilt 1957 · S/N 18-5717 N7297GBraun Ralph H · Moreno Valley, CAS/N 15074638 N7297MVivion Michael T · Bozeman, MTBuilt 1958 · S/N 55597 N7297SBukkila Joan E · Savage, MNBuilt 1967 · S/N 15067997 N72980Kraemer Todd R · Grand Blanc, MIBuilt 1946 · S/N 10181 N72981Knight Andrew J · Wasilla, AKBuilt 1946 · S/N 10182 N72982Burrill Donald M · White City, ORFirst renewal noticeBuilt 1946 · S/N 10183 N72983Seiler David · Anaheim, CAS/N 10184 N72989Meier Perry S · Conroe, TXS/N 10194 N72992Bailey Carlton D Jr · Huntington, WVS/N 10197 N72994Elmore Kimberly L · Norman, OKBuilt 1946 · S/N 10199 N72997Faust Charles B · Long Prairie, MNBuilt 1946 · S/N 10202 N7299MJahnke Eric F · West Palm Beach, FLRevoked, canceledBuilt 1958 · S/N 55599 N7299TOstrowski Sven E · Mullica Hill, NJBuilt 1959 · S/N 46899 N7299XPecoy Edward D · Lyons, NYBuilt 1961 · S/N 15059399 N729CJOld School Flying LLC · Stuart, FLBuilt 2008 · S/N AL-1133 N729HPorter Wade R · Durham, CABuilt 1949 · S/N 19044 N729WDMonroe Greg · Linden, TNBuilt 1960 · S/N 47583 N72AHawkes Arthur E · West Falmouth, MABuilt 1946 · S/N 9337 N72CPGrant Henry R H · Ocracoke, NCBuilt 1973 · S/N 15075051 N72DSGregory Vernon L · Swansea, SCBuilt 1946 · S/N 1012 N72EToronidis Joannis · Ronkonkoma, NYBuilt 1946 · S/N 2918 N72HEHiggins Michael D · Brewer, MES/N 001 N72JBBrown Edward A · Halifax, MABuilt 1980 · S/N 1 N72PFKuck Russell W · Aguila, AZBuilt 1965 · S/N 17253530 N72RRoam Airlines LLC · Eugene, ORBuilt 1952 · S/N 20904 N73002Bureau Todd · Hope, AKBuilt 1946 · S/N 10207 N73003Schwieterman Neal J · Paonia, COBuilt 1946 · S/N 10208 N73009Davenport Ross K · Raleigh, NCBuilt 1946 · S/N 10214 N73011Maurer Christian N · Loveland, OHBuilt 1946 · S/N 10216

Back to AD 94-05-05 R1