Skip to content

Registered aircraft · 26,231

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.

N4365CPeters Patrick J · Wasilla, AKBuilt 1956 · S/N 7EC-388 N4365LPriem Ben · Linwood, MIBuilt 1966 · S/N 17254440 N4366BLittle Andrew P · Fairbanks, AKBuilt 1955 · S/N 26710 N4366UScott Michael D · Chippewa Falls, WIBuilt 1964 · S/N 15060366 N43680Stewarts Aircraft Service Inc · Waynesville, OHBuilt 1946 · S/N 7339 N43697Rozell Andrew D · Muenster, TXBuilt 1946 · S/N 7356 N43698Rawliuk Robert A · Tok, AKBuilt 1946 · S/N 7357 N4369BFlegel Brian E · Milton Freewater, ORBuilt 1955 · S/N 26713 N4369CObrien James J III · Moreno Valley, CABuilt 1956 · S/N 7EC-393 N4369EDatema Michael A · Jackson, CABuilt 1948 · S/N 11CC-195 N436SAClark Vernon · Olalla, WABuilt 1967 · S/N 15067549 N4370CPhillips Nickolas Hunter · Mikana, WIBuilt 1956 · S/N 7EC-394 N4370LAir North Flying Club · Malone, NYBuilt 1966 · S/N 17254447 N4370UNeal Gordon T · Massillon, OHBuilt 1964 · S/N 15060370 N43714Crow LLC · Lake Placid, FLBuilt 1946 · S/N 7373 N4371CMayhew James · Greenfield, INS/N 7EC-395 N4371LPrisk Jack J · Pride, LABuilt 1966 · S/N 17254448 N4371UBarnett Gina L · Columbus, TXBuilt 1964 · S/N 15060371 N4372CLussier John A · Greene, RIS/N 7EC-396 N4373BZenishek Gary D Trustee · Jefferson City, MOBuilt 1955 · S/N 26717 N4373CSchallip Robert G Jr · Barbeau, MIBuilt 1956 · S/N 7EC-397 N4373ETomczak Darrie-Jo L · So Int'L Falls, MNBuilt 1948 · S/N 7DC-32 N4373LWilliams Matthew W · Fort Walton Beach, FLBuilt 1966 · S/N 17254450 N4374CAir-O-Drome Aviation LLC · Caldwell, IDBuilt 1956 · S/N 7EC-398 N4375CStone Philip R · East Syracuse, NYBuilt 1956 · S/N 7EC-399 N4375HOestreich Scott W · Wausau, WIBuilt 1948 · S/N 15-160 N4377BNatural Resources LLC · Arcadia, FLBuilt 1955 · S/N 26721 N4377CThrash Howard G II · Lubbock, TXBuilt 1956 · S/N 7EC-401 N4377DVan Cleave Raymond · Kalispell, MTBuilt 1999 · S/N 1138 N4377EJeffryes Richard B · Creswell, ORBuilt 1948 · S/N 11CC197 N4378EJim Petik And Sons · Keldron, SDBuilt 1948 · S/N 11CC-198 N4378LRegistration Pending · Wentzville, MORegistration pendingBuilt 1966 · S/N 17254457 N4378UWissenbach Richard G · Pinesdale, MTS/N 15060378 N4379BNewell Kenneth L · Wichita, KSBuilt 1955 · S/N 26723 N4379EMiller Andy D · Marana, AZBuilt 1948 · S/N 11CC-199 N4380BThorall Kenneth L · Chugiak, AKS/N 26724 N4381Wright William F · Cleveland, OKBuilt 2000 · S/N 2000 N43814Turk Caleb S · Tahoe City, CAFirst renewal noticeS/N 7473 N4381BBuck William A · Waianae, HIBuilt 1955 · S/N 26725 N4382BBoyd Delbert L · Oroville, CABuilt 1955 · S/N 26726 N4382CBouchard Ron · Lambert, MTBuilt 1956 · S/N 7EC-408 N4382HJohnson Steven D · Pardeeville, WIBuilt 1948 · S/N 15-167 N4382LFielding Gregory J · Holland, MABuilt 1966 · S/N 17254461 N4382U82 Uniform LLC · Tremonton, UTS/N 15060382 N43830Laverty Russell H · Jones, OKBuilt 1946 · S/N 7489 N4383CCummings Nancie Jean · Miami, FLBuilt 1956 · S/N 7EC-409 N4383ETuvman Kenneth B · Excelsior, MNS/N 11CC-200 N4383HRivenbark Maurice G · Floral City, FLBuilt 1948 · S/N 15-168 N4383LHasman Robert B · Flushing, MIS/N 17254462 N4384BMead Aviation LLC · Missoula, MTBuilt 1955 · S/N 26728

Back to AD 94-05-05 R1