Skip to content

Registered aircraft · 6,915

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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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.

N3755QNarwhal Airlines LLC · Odessa, TXS/N 28R-7703116 N3755TAmr Pilot Services LLC · Jersey City, NJS/N 28R-30064 N3757TA&P Paul LLC · Columbia, CTS/N 28R-30066 N3759TVelez Jose C · Port Orange, FLBuilt 1967 · S/N 28R-30068 N3760TArizaga Diana M · Mamaroneck, NYBuilt 1967 · S/N 28R-30069 N3761THupp Michael A · Marietta, OHBuilt 1967 · S/N 28R-30070 N3762TBenson Robert W · Iowa Park, TXBuilt 1967 · S/N 28R-30073 N3763TGorey Chase · Saint Augustine, FLBuilt 1967 · S/N 28R-30074 N3764XAerialsmith LLC · Dunedin, FLS/N 24-4973 N3765MReyner Mark D · Los Lunas, NMBuilt 1978 · S/N 28R-7803191 N3765THakanson Paul J · Norway, MEBuilt 1967 · S/N 28R-30076 N3767QParsons John C · Wichita, KSBuilt 1977 · S/N 32R-7780322 N3767TFd Equipment Rentals · Sacramento, CAS/N 28R-30078 N3768TLofranco Homes LLC · Saratoga Springs, NYBuilt 1967 · S/N 28R-30080 N3769T69 Tango Flying Club · Aliquippa, PAFirst renewal noticeBuilt 1967 · S/N 28R-30081 N376HCMfd Aviation Inc · Middletown, DEBuilt 1976 · S/N 32R-7680322 N3770TWashburn James F · Cochran, GABuilt 1967 · S/N 28R-30082 N3773TVos Real Estate LLC · Holland, MIBuilt 1967 · S/N 28R-30085 N3777TStewart Donald J · Palm City, FLBuilt 1967 · S/N 28R-30089 N3778TVan De Vanter Robert A · Paso Robles, CAS/N 28R-30090 N3779TShultz Martin · Naperville, ILBuilt 1967 · S/N 28R-30091 N377HHJennings Christopher Wyckoff Trustee · Brentwood, TNBuilt 1970 · S/N 39-13 N377SMJrt Flying Co · Roanoke, VABuilt 1977 · S/N 32R-7780223 N377WTAaronian Randall · Kingsburg, CABuilt 1980 · S/N 34-8070283 N3780TBowley Leonard · Newton, ALBuilt 1967 · S/N 28R-30092 N3783Midwest Fling Service Inc · Elgin, NEBuilt 1963 · S/N 24-3553 N3785TZeuner John F · Austin, TXBuilt 1967 · S/N 28R-30098 N3786TSunrise Aviation Inc · Ormond Beach, FLBuilt 1967 · S/N 28R-30099 N3788TMason Kenneth Lee · Siloam Springs, ARBuilt 1967 · S/N 28R-30101 N3789TGullett John H II · Jacksonville, FLBuilt 1967 · S/N 28R-30102 N378RSKempton Larry J III · Grand Junction, COBuilt 1978 · S/N 28R-7837239 N3791TMakowski Edward J · Barberton, OHBuilt 1967 · S/N 28R-30104 N3792TBrowning Marvin Robert · Berthoud, COBuilt 1967 · S/N 28R-30105 N3795TCrossen Executive LLC · Missouri City, TXBuilt 1967 · S/N 28R-30108 N3796MRoth Jacques A · San Rafael, CABuilt 1978 · S/N 28R-7803194 N3796TWhitmore Allen R · Crestview, FLBuilt 1967 · S/N 28R-30109 N3797TMarshall Patrick R · Trail, ORBuilt 1967 · S/N 28R-30110 N3799TFly 99t LLC · Pompano Beach, FLBuilt 1967 · S/N 28R-30112 N37HEBjbipbip Corp Trustee · Wilmington, DES/N 24-4514 N37KSNarwani Anil V · Orlando, FLBuilt 1977 · S/N 28R-7703257 N37PFSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N 34-8070359 N37REGiroux Aeronautical Company LLC · Fulton, NYBuilt 1976 · S/N 32R-7780114 N37SACampbell John R Trustee · Saint Leo, FLBuilt 1972 · S/N 34-7250046 N37USSouthern Aircraft Consultancy Inc Trustee · Bergh Apton NflkRegistration ineffective or invalidBuilt 1980 · S/N 34-8070111 N3801TSeefeldt John V · Monticello, MNBuilt 1967 · S/N 28R-30115 N3804TMarello Thomas J · Westminster, MDBuilt 1967 · S/N 28R-30118 N3805TEyth Isaac S · Fe Warren Afb, WYBuilt 1969 · S/N 28R-30119 N3806TFacklair LLC · Granville, OHBuilt 1967 · S/N 28R-30120 N3809TMiller Jo Ann · Atlanta, GABuilt 1967 · S/N 28R-30124 N3810TN3810t LLC · Kalispell, MTS/N 28R-30125

Back to AD 97-01-01 R1