Skip to content

Registered aircraft · 1,344

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

N102ASG&P Cheetah LLC · Honolulu, HIBuilt 1977 · S/N AA5A0514 N105NABond Gary G · Harvest, ALBuilt 1978 · S/N AA5B-1016 N1082ZJohnson Henry D · Buena Park, CABuilt 1976 · S/N AA5B0346 N10SXAerodynamics Unlimited LLC · Oklahoma City, OKBuilt 1977 · S/N AA5A0303 N1118AKing Charles W · Kelseyville, CABuilt 1976 · S/N AA5A-0192 N111LAAmmons Curtis D · Hernando, MSBuilt 1976 · S/N AA5B-0249 N112FTColesanti Richard A · Poughquag, NYBuilt 1975 · S/N AA5B-0180 N114BJBig Q Aviation · Helena, MTS/N AA5B0656 N1169HSwihart Matthew Allen · San Marcos, TXBuilt 1975 · S/N AA5B-0063 N117LWBlasdel Michael J · Fort Worth, TXBuilt 1975 · S/N AA5B-0057 N119STSandberg Brian · Lancaster, CABuilt 1975 · S/N AA5B-0119 N11JVHoltz Jeff · Liberty Lake, WABuilt 1977 · S/N AA5B0593 N11LTG T Flying Club LLC · Bellaire, TXBuilt 1977 · S/N AA5B0616 N11ZSSergeant John F C · Fort Myers, FLS/N AA5A-0403 N1234DGonzales Jaime T · Mandeville, LABuilt 1979 · S/N AA5A0860 N123ESPlane Fun Inc Tr Trustee · Snellville, GABuilt 1979 · S/N 1021 N125RMGurtman Samuel · Deerfield, ILBuilt 1978 · S/N AA5B0698 N126DGSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N AA-5B-0099 N12GANy Flying Tigers LLC · Ronkonkoma, NYBuilt 1977 · S/N AA5B0635 N130THDelage Jeffrey R · Biddeford, MEBuilt 1977 · S/N AA5A0398 N1317RVaughan Andy C · Sacramento, CABuilt 1977 · S/N AA5A0323 N131KYJett Edward C Jr · Bloomfield, KYBuilt 1979 · S/N AA5A0828 N1353NSubsonic Aviation Leasing LLC · Grandville, MIBuilt 1979 · S/N AA5B1242 N144CCNightingale William T III · Rancho Cucamonga, CABuilt 1975 · S/N AA5B-84 N144RLHanshew James M · Phoenix, AZS/N AA5B1034 N148RRDunbar Richard · El Dorado Hills, CABuilt 1978 · S/N AA5B-1008 N1502RSale Reported · San Diego, CASale reported, pending cancellationBuilt 1974 · S/N AA5B-0002 N1503RBeck Wally J · Davenport, IABuilt 1974 · S/N AA5B-0003 N1504RFlying Tiger LLC · Broomfield, COBuilt 1974 · S/N AA5B-0004 N1508RAmspoker David A · Kingman, AZBuilt 1975 · S/N AA5B-0030 N1515ROwen Ray M · Columbia Station, OHBuilt 1974 · S/N AA5B-0015 N1516RMckenzie Pools Inc DBA · Springfield, ORBuilt 1974 · S/N AA5B-0016 N1519RSims John · Ingleside, TXBuilt 1974 · S/N AA5B-0019 N1520Littler David E · Largo, FLBuilt 1978 · S/N AA5B0957 N1520RCastro Jose M · Conway, ARS/N AA5B-0020 N1521RPerkins J R III · The Dalles, ORBuilt 1975 · S/N AA5B-0021 N1523RDement Myers Michael W · Newberg, ORBuilt 1975 · S/N AA5B-0023 N1527RFilkins Barbara L · Fillmore, CABuilt 1975 · S/N AA5B-0027 N1529RBall Chad M · Delaware, OHBuilt 1975 · S/N AA5B-0029 N1531RMorgan Virginia K · Artesian, SDBuilt 1975 · S/N AA5B-0031 N1532RAdkins Todd D · Manassas, VABuilt 1975 · S/N AA5B-0032 N1533RAnderson Michael · Byhalia, MSBuilt 1975 · S/N AA5B-0033 N1536RCape Cod Aero Club LLC · Falmouth, MABuilt 1975 · S/N AA5B-0036 N1538RAction Aerospace LLC · Bluffton, SCBuilt 1975 · S/N AA5B-0038 N1540RPolar Tigers Inc · North Oaks, MNBuilt 1975 · S/N AA5B-0040 N1541RHall Daniel · Haskell, OKBuilt 1975 · S/N AA5B-0041 N1542RHoose Michael J · Cortland, NYS/N AA5B-0042 N1543RHettlinger Eric R · Terre Haute, INBuilt 1975 · S/N AA5B-0043 N1545RSanders Harrison S · West Columbia, TXBuilt 1975 · S/N AA5B-0045 N1548RJohnson Jimmy G A III · Edmond, OKBuilt 1975 · S/N AA5B-0048

Back to AD 76-22-09