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.

N3811MBanks Jerry A · Collierville, TNBuilt 1969 · S/N 28R-35200 N3811TDeleon Muniz Mario Antonio · Riverside, CABuilt 1967 · S/N 28R-30126 N38123Huber Weylin L · Aberdeen, SDBuilt 1977 · S/N 28R-7703178 N38127Trager Limestone LLC · Chillicothe, MOS/N 32R-7780387 N38128Tobias Gregory L · Ottawa Lake, MIS/N 32R-7780388 N3812TGtm Services LLC · Ames, IABuilt 1967 · S/N 28R-30127 N38133White Leroy · Enid, OKS/N 32R-7780389 N3813TCenturion Transportation LLC · Weatherford, OKBuilt 1967 · S/N 28R-30129 N3815EHonest Dog Farms LLC · Fayetteville, GABuilt 1966 · S/N 30-1335 N3816T1 Vision General Aviation LLC · Sioux City, IABuilt 1967 · S/N 28R-30132 N38173Tingley Robert D · Watham, MABuilt 1977 · S/N 34-7770289 N3818TMccawley Gerald J · Parksley, VABuilt 1967 · S/N 28R-30134 N3819TChism Alicia L · Lawrence, KSBuilt 1967 · S/N 28R-30136 N38200Hauzer Alex · Golden, COBuilt 1977 · S/N 28R-7737083 N38201Touchstone Justin Reed · Hattiesburg, MSS/N 28R-7703188 N38203Wdiaz Design Inc · Sunny Isles Beach, FLBuilt 1977 · S/N 28R7703189 N38205Albright John A · Richmond, INBuilt 1977 · S/N 32R-7780403 N38206Bean John R · San Antonio, TXBuilt 1977 · S/N 32R-7780404 N38208Jb Airways LLC · Linden, PABuilt 1977 · S/N 32R-7780405 N3820T3820t Aviation LLC · Fort Smith, ARBuilt 1967 · S/N 28R-30137 N3821TDoty David W · Lakeland, FLBuilt 1968 · S/N 28R-30959 N3822TVanderblom David Y · Oxford, ALBuilt 1967 · S/N 28R-30139 N3824TStevens Zane Kelly · Carthage, TNBuilt 1967 · S/N 28R-30141 N38256Ringler Neil H · Baldwinsville, NYBuilt 1977 · S/N 28R-7737085 N3825TArmstrong Aviation Services LLC · Freeport, PABuilt 1967 · S/N 28R-30143 N38273Southern Aircraft Consultancy Inc Trustee · Casper, WYS/N 28R-7737086 N38275Von Duyke Mark A · Des Moines, WABuilt 1977 · S/N 28R-7703198 N3827TBrauer Noah J · Covington, KYBuilt 1967 · S/N 28R-30145 N38294Aerograzmar LLC · Bloomfield, NJBuilt 1977 · S/N 28R-7737087 N3829TFreese Pamela L · Frederic, WIBuilt 1967 · S/N 28R-30147 N38305Wulf Aerospace LLC · Santa Rosa Beach, FLBuilt 1977 · S/N 32R-7780413 N3830TStevenson Shane C · Sicklerville, NJBuilt 1967 · S/N 28R-30148 N3831MWebster Mark A · Chino Hills, CABuilt 1978 · S/N 28R-7837138 N3832TFrysinger Melvin D · Weatherford, TXBuilt 1967 · S/N 28R-30150 N38334Gsm Air LLC · Old Tappan, NJBuilt 1977 · S/N 32R-7780415 N38338Rafter W Ranches LLC · Johnson, KSBuilt 1977 · S/N 32R-7780416 N3834TJsl Instructional Services LLC · Fort Worth, TXS/N 28R-30152 N3834ZImmen David F · Bonanza, ORBuilt 1978 · S/N 34-7870225 N3835THuber Charles H · Medina, OHBuilt 1967 · S/N 28R-30153 N38368Dubisar Milo Richard · Redmond, ORBuilt 1977 · S/N 32R-7780419 N3837TRemsberg Charles · University Place, WABuilt 1967 · S/N 28R-30155 N38382Syracuse Aviation LLC · Cicero, NYBuilt 1977 · S/N 28R-7737091 N38385Wahl Michael John · Jefferson, IABuilt 1977 · S/N 28R-7703211 N38388Hosanna Industries Inc · Gibsonia, PABuilt 1977 · S/N 32R-7780422 N3838TFundamentals Aircraft Leasing LLC · Erie, PABuilt 1967 · S/N 28R-30157 N3839TN3839t LLC · Copley, OHS/N 28R-30158 N383DANew Mexico Flying Eagle Inc · Tucson, AZBuilt 2003 · S/N 2844098 N38430Vp Aviation Inc · Bloomington, INS/N 32R-7780426 N38440Decoria Dustin E · Kennewick, WABuilt 1977 · S/N 28R-7703218 N38444Middlebrook Lary · Lakeside, CABuilt 1977 · S/N 28R-7703221

Back to AD 97-01-01 R1