Skip to content

Registered aircraft · 17,027

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.

N3755UHendrickson Justin R · Twin Falls, IDBuilt 1963 · S/N 18255155 N3755YCecil Enterprises LLC · Gig Harbor, WABuilt 1963 · S/N 21058255 N3756JLong Donald R · Seneca, SCBuilt 1966 · S/N 15065056 N3756XStephens Tanner B · Palmer, AKBuilt 1968 · S/N 21059075 N3758FTvpx Aircraft Solutions Inctrustee · North Salt Lake, UTS/N 17255253 N3758LN3758l LLC · Titusville, FLBuilt 1965 · S/N 17253927 N3758RDrager Timothy L · Pottstown, PABuilt 1966 · S/N 17255558 N3759YManagement Support Services LLC · Naturita, COBuilt 1963 · S/N 21058259 N375HWWallace Charles · Fayetteville, ARBuilt 1963 · S/N 21058251 N375LARegistered aircraftBuilt 1965 · S/N 17252722 N375MKIntegrity S&J Properties LLC · Amarillo, TXBuilt 1963 · S/N 21058252 N3760JWeeks Ryan A · Sneads Ferry, NCBuilt 1966 · S/N 15065060 N3760YHarris Stephen T · Williamstown, KYBuilt 1963 · S/N 21058260 N3761LBas Part Sales LLC · Greeley, COS/N 17253930 N3763RPrimo Aviation LLC · Collierville, TNBuilt 1966 · S/N 17255563 N3763UHunter James C · Shelton, WABuilt 1964 · S/N 18255163 N3765JSatanta Flying Service Inc · Satanta, KSS/N 15065065 N3765RLevin Robert · Roseburg, ORBuilt 1966 · S/N 17255565 N3765SKennedy Patrick M · Great Barrington, MABuilt 1971 · S/N 17701629 N3765YBott David F · Yukon, OKBuilt 1963 · S/N 21058265 N3766LSygnet Lenard M · Pottstown, PABuilt 1965 · S/N 17253935 N3766YPyanov Mark · Clinton, MSS/N 21058266 N3767JHalbur Wesley D · Heron Lake, MNBuilt 1966 · S/N 15065067 N3768JWheeler Kevin M Trustee · Comstock Park, MIBuilt 1966 · S/N 15065068 N3768RStretz Scott P · Lees Summit, MOBuilt 1966 · S/N 17255568 N3769JRatner Robert D · Swan Lake, NYBuilt 1966 · S/N 15065069 N3769UNorthey Scott A · Mazama, WABuilt 1963 · S/N 18255169 N3770FSchoenberger Lance · Shakopee, MNBuilt 1966 · S/N 17255265 N3770JAzad Raja M · Hawthorne, CABuilt 1966 · S/N 15065070 N3770LJ&C Aviation LLC · South Boston, VABuilt 1965 · S/N 17253939 N3770RBowery Michael P · Quinton, VABuilt 1966 · S/N 17255570 N3770UPetersen Christopher Erik · Morton, ILBuilt 1964 · S/N 18255170 N3770YBig Bend C C Foundation · Moses Lake, WABuilt 1963 · S/N 21058270 N3771JKozel Thomas · Pottstown, PABuilt 1966 · S/N 15065071 N3771LFlying Bs LLC · Midlothian, TXBuilt 1966 · S/N 17253940 N3771RMccay Brian D · Earlysville, VABuilt 1966 · S/N 17255571 N3772RRiver Town Aviation LLC · Williamstown, WVBuilt 1966 · S/N 17255572 N3772YKossuth Keith E · Sleepy Hollow, CAS/N 21058272 N3773JBertrand Aviation LLC · Brookville, KSBuilt 1966 · S/N 15065073 N3773RBlair Richard J · Medina, OHS/N 17255573 N3774LKarr Stacy A · Hogansville, GABuilt 1965 · S/N 17253943 N3774YLanning 2 Aviation LLC · Amarillo, TXBuilt 1963 · S/N 21058274 N3775LLee Michael Min · Dayton, OHBuilt 1965 · S/N 17253944 N3776FRegistration Pending · Denver, NCRegistration pending, pending cancellationS/N 17255271 N3776LStramel Bert Jon · Colby, KSBuilt 1965 · S/N 17253945 N3776USchmit Joe · Ventura, IAS/N 18255176 N3778RSwede Aviation LLC · Tucson, AZBuilt 1966 · S/N 17255578 N3778UBlue Goose Aviation Inc · Polson, MTBuilt 1964 · S/N 18255178 N3778YTime Air LLC · Mendon, UTBuilt 1965 · S/N T210-0034 N3779FTiraphatna Jittakorn · Arlington, TXS/N 17255274

Back to AD 72-03-03 R3