Skip to content

Registered aircraft · 1,267

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:88-21-07-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:88-21-07-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:88-21-07-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:88-21-07-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:88-21-07-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:88-21-07-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.

N3346PDramstad Flying Service LLC · Helena, MTS/N 23-1299 N3353PHeffron Jacob L · Little Falls, MNBuilt 1958 · S/N 23-1308 N3363PDubois Aviation Inc · Chino, CABuilt 1958 · S/N 23-1320 N3366Sutton Aircraft Salvage LLC · Palmer, AKS/N 23-1919 N3367PJackson Lee Roy Jr · Needville, TXBuilt 1958 · S/N 23-1324 N3377PFlying High LLC · Gore, VABuilt 1958 · S/N 23-1337 N3388PMorrison Maria · Port Townsend, WABuilt 1958 · S/N 23-1351 N3389PLapeyrouse Charles L · Raceland, LABuilt 1958 · S/N 23-1352 N338SSSieli Paul III · Griffin, GAS/N 27-224 N339CTPatel Niral G · Atlanta, GABuilt 1974 · S/N 27-7405350 N33RWSpencer Joseph C · Asheboro, NCBuilt 1960 · S/N 23-1948 N33SAMcwherter Holdings Inc · Asheboro, NCS/N 27-3370 N3403PCarper Ryan W · Marietta, OHBuilt 1958 · S/N 23-1367 N341CHAce Flight Center Inc · St Thomas, VIBuilt 1980 · S/N 27-8154006 N3420PKeyuravong Pisonth · Anchorage, AKBuilt 1958 · S/N 23-1384 N3430PChamberlain Paul E · Troup, TXBuilt 1958 · S/N 23-1396 N3434PNasair LLC · Flower Mound, TXBuilt 1958 · S/N 23-1401 N3442POttmann Robert · Indialantic, FLBuilt 1958 · S/N 23-1410 N3447PSimonovich Sheldon K · Fredericksburg, VABuilt 1958 · S/N 23-1418 N3448PDabney Richard W · Tanner, ALBuilt 1958 · S/N 23-1419 N3456PBels Holdings LLC · Albert Lea, MNBuilt 1958 · S/N 23-1428 N3457PSewade Dawn M · New River, AZBuilt 1958 · S/N 23-1429 N345JGGo Fly Inc · Spring Hill, FLBuilt 1959 · S/N 23-1825 N3468PHilligoss Forrest R · Brownsburg, INBuilt 1958 · S/N 23-1442 N3475PEdixon James Richard II · Cameron Park, CABuilt 1958 · S/N 23-1449 N3494AWheeler Michael R · Peculiar, MOBuilt 1962 · S/N 27-2197 N3494BLiguori Fred C · Granby, CTBuilt 1955 · S/N 23-282 N3497PKitchens Craig N · Salt Lake City, UTBuilt 1958 · S/N 23-1473 N3499PTinny Twister Aviation LLC · Fort Myers, FLBuilt 1958 · S/N 23-1475 N349CHAce Flight Center Inc · St Thomas, VIBuilt 1968 · S/N 27-3949 N34DAGlover William S · Mount Pleasant, TXBuilt 1958 · S/N 231469 N34KKLe Ferrand Colette · Kalispell, MTBuilt 1972 · S/N 27-7304946 N355MDelaware Trust Company Owner Trustee · Wilmington, DES/N 273972 N3611BRestorations & Rentals LLC · Tulsa, OKBuilt 1970 · S/N 27-4579 N362BMAmerican Valet Air Inc · Wilmington, DEBuilt 1973 · S/N 27-7305171 N362BPLight & Variable LLC · Arlington, VABuilt 1979 · S/N 27-7954048 N367PBuzzard Air Service LLC · Carleton, MIS/N 23-367 N370Bas Part Sales LLC · Greeley, COBuilt 1965 · S/N 27-3084 N370MDAlmost There Air LLC · Daytona Beach, FLBuilt 1972 · S/N 27-4814 N370SASharp Spears LLC · Vero Beach, FLBuilt 1979 · S/N 278054005 N370TBellas Business LLC · Kalispell, MTBuilt 1958 · S/N 23-1506 N371AMPreuss Andrew J · North Charleston, SCBuilt 1968 · S/N 27-4005 N371DSCl Finney Aviation LLC · Benton, KSBuilt 1955 · S/N 23-153 N374PDavhen Aero LLC · Anderson, SCBuilt 1974 · S/N 27-7405410 N375AZSale Reported · Guatemala CitySale reportedS/N 27-7854038 N377DWSoutheastern Aircraft Inc · Birmingham, ALBuilt 1965 · S/N 27-3063 N385WKTriva Solutions LLC · El Paso, TXS/N 27-4130 N388METrinity Aviation Group LLC · Hudson Oaks, TXBuilt 1955 · S/N 23-322 N390ASOcala Aviation Services Inc · Ocala, FLS/N 27-3117 N391MGHagedorn Aviation Inc · Columbus, OHBuilt 1975 · S/N 27-7554131

Back to AD 88-21-07 R1