Skip to content

Registered aircraft · 1,772

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

N1000SButler County Warbirds Inc · Middletown, OHBuilt 1972 · S/N AA5-0107 N100YAShelton Joel T · Grass Valley, CAS/N AA5-0086 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 N1104RInternational Air Services Inc Trustee · Carson City, NVS/N AA5-0471 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 N119EKBrady Michael K · Sammamish, WABuilt 1974 · S/N AA5-0595 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 N12PZA5 Flight Club LLC · Saint Cloud, FLBuilt 1974 · S/N AA5-0622 N130GWBruckner Peter J · Rochester, NHBuilt 1975 · S/N AA50707 N130THDelage Jeffrey R · Biddeford, MEBuilt 1977 · S/N AA5A0398 N1317RVaughan Andy C · Sacramento, CABuilt 1977 · S/N AA5A0323 N1318RWright Wayne S · Linden, MIBuilt 1974 · S/N AA5-0718 N1319RJustusson William · Punta Gorda, FLS/N AA5-0719 N131KYJett Edward C Jr · Bloomfield, KYBuilt 1979 · S/N AA5A0828 N1321RRamineni Raja S · Fort Mill, SCBuilt 1974 · S/N AA5-0721 N1327RYost Alan · North Andover, MABuilt 1974 · S/N AA5-0727 N1328RTrout Fred C · Dallas, GABuilt 1974 · S/N AA5-0728 N1329RDeltondo Ralph P · Fullerton, CAS/N AA5-0729 N1331RGalindo John S · Hurst, TXBuilt 1975 · S/N AA5-0731 N1333RNorris Randy K · Sylvania, GABuilt 1975 · S/N AA5-0733 N1335RHughes Michael · Harvard, MABuilt 1975 · S/N AA5-0735 N1336RManus Phillip P · Tucson, AZS/N AA5-0736 N1337RZimmerman Christopher Paul · Canandaigua, NYBuilt 1975 · S/N AA5-0737 N1339RWilcox Marion L Trustee · La Mesa, CABuilt 1975 · S/N AA5-0739 N1341RTmp Aviation LLC · Altamonte Springs, FLBuilt 1975 · S/N AA5-0741 N1342RGladden Thomas E · Otis Orchards, WABuilt 1975 · S/N AA5-0742 N1345RGrumman N1345r LLC · Benton Harbor, MIBuilt 1975 · S/N AA5-0745 N1346RPaul Joshua Daniel · Murrieta, CABuilt 1975 · S/N AA5-0746 N1347RCharles Kaplove Md Inc · Novato, CABuilt 1975 · S/N AA5-0747 N1348RMargolien Brooks · Orange, MABuilt 1975 · S/N AA5-0748 N1353NSubsonic Aviation Leasing LLC · Grandville, MIBuilt 1979 · S/N AA5B1242 N1355RFly Guys LLC · Arcata, CABuilt 1975 · S/N AA5-0755 N1359REllingson Jason J · Edina, MNBuilt 1975 · S/N AA5-0759 N1361RLeslie Michael H · Ashburn, VABuilt 1975 · S/N AA5-0761

Back to AD 89-18-08