Skip to content

Registered aircraft · 17,028

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:72-03-03-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3') 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:72-03-03-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
  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:72-03-03-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
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.

N8986SSchneider Jackson L · Florissant, MOBuilt 1965 · S/N 15062286 N898AHAerospace Asset Holdings LLC · Wilmington, DES/N 207-00123 N8992GKing William · Tallulah, LABuilt 1970 · S/N 18260532 N8993SRopp Dale Arden · Bemidji, MNBuilt 1965 · S/N 15062293 N8994GRussmann Nicholas S · Merit, TXBuilt 1970 · S/N 18260534 N8994SMorel Charles Paul IV · Morgan Hill, CABuilt 1965 · S/N 15062294 N8995SLonneman Robert P · Edgewood, KYBuilt 1965 · S/N 15062295 N8996SSoaring Thunderbirds Inc · Canton, OHS/N 15062296 N8997SRed Barn Ag & Home Inc · Westville, OKBuilt 1966 · S/N 15062297 N8999SLewis Darrell K · Morehead, KYBuilt 1965 · S/N 15062299 N899PPT&M Air Az LLC · Phoenix, AZBuilt 1964 · S/N 18255946 N899SPPolyspray Corp · Asheboro, NCBuilt 1967 · S/N R172-0101 N89JFWitt Roger S · Spencer, MABuilt 1966 · S/N 18257089 N89KSRoss Tim · Las Vegas, NVBuilt 1968 · S/N 18259172 N89SFMiller Luke · Redmond, WABuilt 1976 · S/N 177RG1003 N89WWAley Jeffrey S II · Granby, COBuilt 1967 · S/N 17255978 N8AJBs Designs Inc · Decatur, TXFirst renewal noticeBuilt 1966 · S/N P206-0335 N8EKWindermere Wings LLC · Altamonte Springs, FLBuilt 1964 · S/N 18255353 N8NURbc Aviation LLC · Hollywood, FLBuilt 1966 · S/N T210-0220 N8PWMiranda Alexander · Homestead, FLBuilt 1969 · S/N 15071312 N8TRAviation Academy LLC · Wichita, KSBuilt 1972 · S/N 17260672 N8YQHartlieb Gordon Wesley · Anchorage, AKBuilt 1972 · S/N 17701718 N90052Laz Stanley R · Snohomish, WABuilt 1977 · S/N 177RG1140 N9006GAltomari Richard J · Pittsburgh, PABuilt 1970 · S/N 18260546 N9007GKem Air Enterprises LLC · Kalispell, MTBuilt 1970 · S/N 18260547 N900DFWaters Aero-Marine Inc · South Thomaston, MEBuilt 1973 · S/N 20700234 N900EDSpradling James · Fremont, OHBuilt 1969 · S/N 18259731 N9012GCockrell Carroll G · Mount Sterling, KYBuilt 1970 · S/N 18260552 N9016GSkydive Duluth Superior LLC · Superior, WIBuilt 1971 · S/N 18260556 N9018GSimpkins Lynn DBA · Costa Mesa, CABuilt 1971 · S/N 18260558 N90193Renfro Michael W · Bethel, AKBuilt 1969 · S/N 20700007 N901JWings Over Texas Holdings LLC · Denton, TXBuilt 1969 · S/N 17258779 N901JMGuderjahn Raymond · Garden Plain, KSBuilt 1962 · S/N 18253901 N901LJPegasus Flight Resources LLC · Charlotte, VTS/N 6715191 N901MPMccole Kevin · Brookline, NHS/N 17259565 N901PWFlywerx LLC · Anchor Point, AKBuilt 1969 · S/N 18259980 N901RJMiller James A · Granada Hills, CABuilt 1965 · S/N 17253429 N901TGWestland Aviation LLC · Lake Havasu City, AZBuilt 1968 · S/N 17257312 N9020GAmeritek LLC · Tuttle, OKBuilt 1971 · S/N 18260560 N9021GRector Edward L · Nederland, TXBuilt 1971 · S/N 18260561 N9023GBull Bren C · Kingsville, TXBuilt 1971 · S/N 18260563 N9024GJessop Jacob N · Cedar City, UTBuilt 1971 · S/N 18260564 N90252Weigman Michael S · Altamonte Springs, FLBuilt 1967 · S/N R1720191 N9025GN9025g LLC · Indianapolis, INBuilt 1971 · S/N 18260565 N9026GTekoa Skylane Club · Chattaroy, WAS/N 18260566 N9027GCessna Flyers LLC · Spartanburg, SCBuilt 1971 · S/N 18260567 N9029DKemp Ted · Pleasant Shade, TNS/N 17254099 N902HMacvey Troy R · Milan, INBuilt 1971 · S/N 17259252 N9033GHillside Air Service LLC · Roanoke, INS/N 18260573 N9034GDanielle K Heckman · Crystal River, FLBuilt 1971 · S/N 18260574

Back to AD 72-03-03 R3