Skip to content

Registered aircraft · 6,916

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.

N6136PPlane Fun Inc Tr Trustee · Snellville, GABuilt 1959 · S/N 24-1236 N6137JBradford III Properties LLC · Huntersville, NCBuilt 1976 · S/N 32R-7680309 N6138JLockwood Elijah T · Dayton, OHBuilt 1976 · S/N 32R-7680310 N613FPlane Fun Inc Tr Trustee · Snellville, GABuilt 1970 · S/N 39-45 N6140HDiaz Jesse · Dothan, ALBuilt 1977 · S/N 28R-7803089 N6140PBrake It LLC · Pensacola, FLBuilt 1959 · S/N 24-1241 N6141PRs Agricultural Operations LLC · Dell City, TXS/N 24-1242 N614JDCc Aviation Inc · Tracy, CABuilt 1967 · S/N 30-1517 N614RSecker David · San Jose, CAFirst renewal noticeBuilt 1964 · S/N 30-658 N614XGMaher Jay A · Highlands Ranch, COBuilt 1977 · S/N 28R-7703262 N6150PCobb Berrien · Smyrna, GABuilt 1959 · S/N 24-1251 N6151PRoberson Michael B · Winterville, NCBuilt 1959 · S/N 24-1252 N6153JLange Scott A · Rapid City, SDBuilt 1976 · S/N 28R-7635303 N6154PLonhart Donald E · Greeley, COBuilt 1959 · S/N 24-1255 N6155PSturm Steve G Trustee · Springdale, ARBuilt 1959 · S/N 24-1256 N6157PFrazier Jon A · Vista, CABuilt 1959 · S/N 24-1258 N6159HJeva Ventures LLC · Charleston, SCBuilt 1977 · S/N 28R-7837055 N6160PBbg Air Ventures LLC · Chandler, AZBuilt 1959 · S/N 24-1261 N6161HCouture Michael E · Conway, NHS/N 28R-7803091 N6162PKiester Michael E · Duncan, OKBuilt 1959 · S/N 24-1263 N6163HSodolak Craig A · Magnolia, TXBuilt 1977 · S/N 28R-7803092 N6163PCommache Avn Inc · Flint, MIBuilt 1960 · S/N 24-1264 N6164JSchumar James F · Grand Rapids, MIBuilt 1976 · S/N 28R-7635315 N6166HMccolley Gregory · Glendale, AZBuilt 1977 · S/N 28R-7803093 N6167PRico Nathaniel J · Astoria, ORBuilt 1959 · S/N 24-1268 N6168HWayne Air LLC · Collinwood, TNBuilt 1977 · S/N 32R-7880046 N6169PKlier John M · Alpine, CABuilt 1959 · S/N 24-1270 N616BBHarp Air LLC · Lowell, MIBuilt 1978 · S/N 34-7870288 N616SRBarendregt Melvin E · Heyburn, IDS/N 24-1800 N6170JSeeler John A · Bristol, NHBuilt 1976 · S/N 28R-7635316 N6170PMaurer Bruce C · Power, MTBuilt 1959 · S/N 24-1271 N6171HTyler Cherokee 235 LLC · Lindale, TXBuilt 1977 · S/N 32R-7880047 N6173JMinor Michael W · Summerland Key, FLS/N 32R-7680324 N6173PSwenson James A · Lake Point, UTBuilt 1959 · S/N 24-1274 N6174JAloms Enterprises LLC · Marietta, GABuilt 1976 · S/N 32R-7680325 N6174PAbernathy Larry D · Vernon, TXBuilt 1959 · S/N 24-1275 N6178PFolse Eldred J · North Las Vegas, NVBuilt 1959 · S/N 24-1280 N6179JSanders Jeffrey A · Aurora, COBuilt 1976 · S/N 32R-7680326 N617ECHungerford Brett · Cincinnati, OHBuilt 1975 · S/N 32R-7680096 N617EDMente Charles · Homestead, FLBuilt 1968 · S/N 24-4765 N6181PLowe David M · Sacramento, KYBuilt 1959 · S/N 24-1283 N6184PCollins Michael J · Chandler, AZBuilt 1959 · S/N 24-1286 N6187PFlowers Ricky B · Klamath Falls, ORBuilt 1959 · S/N 24-1289 N6190JMiller James A · Fairbanks, AKBuilt 1976 · S/N 32R-7680329 N6192PLevin Sidney M · Buffalo Grove, ILBuilt 1959 · S/N 24-1294 N6194HJones Frederick W · Burgaw, NCBuilt 1977 · S/N 28R-7803096 N6194PCrosby Tire & Body Shop Inc · Crosby, NDBuilt 1959 · S/N 24-1296 N6197JN6197j LLC · Dallas, TXBuilt 1976 · S/N 28R-7635319 N6199HBig Sky Flyers LLC · Stevens, PAS/N 32R-7880048 N6199JReece Donald E · Odessa, FLS/N 32R-7680330

Back to AD 97-01-01 R1