Skip to content

Registered aircraft · 54,015

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

N6167CSnyder Larry G · Holland, NYBuilt 1979 · S/N 21063818 N6167EMiller James C III · Papillion, NES/N 15059791 N6167FJohnson Susan J · Chelan, WABuilt 1973 · S/N A1500437 N6167NMillhorn Farms Inc · Worley, IDS/N 18504303 N6167TBurton William F · Shiloh, NJBuilt 1964 · S/N 15060867 N61680Kaye Linda · Grove, OKBuilt 1975 · S/N 17264724 N61683Migdalski Randall C · Pembroke Pines, FLBuilt 1975 · S/N 17264727 N61684Odyssey Aircraft LLC · Topeka, KSBuilt 1975 · S/N 17264728 N61687Advanced Rehab Specialties Pa · Leesburg, FLS/N 17264731 N61689Bc 414 LLC · Los Angeles, CABuilt 1975 · S/N 17264732 N6168BSafety Source LLC · Kirkland, WAS/N 34168 N6168EFoster Marcus R · Mesa, AZBuilt 1958 · S/N 46268 N6168NRegistered aircraftBuilt 1978 · S/N 21062939 N6168SFerrell William W II · Flagstaff, AZBuilt 1980 · S/N R18201635 N61692Pittsburgh Institute Of Aeronautics · West Mifflin, PABuilt 1975 · S/N 17264734 N61696Bakker Margaret E Trustee · Petaluma, CABuilt 1975 · S/N 17264737 N61697L&W Aircraft Investment LLC · Homestead, FLBuilt 1975 · S/N 17264738 N61699Erickson Steve · St Michael, MNBuilt 1975 · S/N 17264740 N6169BTjs Plane LLC · Renton, WABuilt 1957 · S/N 34169 N6169EVick Troy · Normangee, TXS/N 46269 N6169FWatrud Joel Carl · Waskish, MNS/N 21059069 N6169GKingdom Air Corps · Sutton, AKBuilt 1969 · S/N 15071669 N6169RN999gk LLC · Nantucket, MAS/N 172RG0102 N6169TZelner Gregory · Merritt Island, FLBuilt 1964 · S/N 15060869 N616AADowns Kenneth · Houston, TXBuilt 1975 · S/N 17265524 N616JHHarcatco LLC · Corsicana, TXS/N 18504290 N616PJLarson Paul S · San Carlos, CABuilt 1979 · S/N 18267121 N616SFAmelia Reid Aviation LLC · San Jose, CABuilt 1980 · S/N 172RG0740 N616SKSuperior Flying Services LLC · Superior, WIBuilt 1979 · S/N 17273381 N616WERodriguez Norberto R · Inwood, NYBuilt 1963 · S/N 18254925 N61700Torres Ramon L · Mulberry, FLS/N 17264741 N61701Jls Aviation LLC DBA · Fredericksburg, VABuilt 1975 · S/N 17264742 N61703Beising Steven · Las Vegas, NVBuilt 1975 · S/N 17264744 N61704Glick Mervin L · Stanardsville, VABuilt 1975 · S/N 17264745 N61705White Robert Tyler · Pleasanton, CABuilt 1977 · S/N 18265728 N61707Spartan National Holdings LLC · Missoula, MTBuilt 1975 · S/N 17264747 N61709Caldwell Clifton · Sterling City, TXBuilt 1975 · S/N 17264748 N6170BEnglish Stanley P · Anchorage, AKBuilt 1957 · S/N 34170 N6170FWilkins Raymond E · Osceola, IABuilt 1968 · S/N 21059070 N6170NGarmin210 LLC · Willard, MOBuilt 1978 · S/N 21062941 N6170RBrown Michael R · Huntsville, ALBuilt 1965 · S/N T210-0070 N6170SNice Flight LLC · Medford, ORBuilt 1980 · S/N R18201637 N6170THerman David B · Seattle, WABuilt 1964 · S/N 15060870 N61710Bob Hoover Academy Inc · Salinas, CABuilt 1975 · S/N 17264749 N61713Miller Melanie L · Spanaway, WABuilt 1975 · S/N 17264750 N61718Ortman Bernard R · Bozeman, MTBuilt 1975 · S/N 17264753 N6171EAvequities Inc · Dallas, TXBuilt 1958 · S/N 46271 N6171FDohrenwend Mark G · Owensboro, KYBuilt 1968 · S/N 21059071 N6171GMission Flight Academy · Yucaipa, CAS/N 15071671 N61727Mays Gloria J · College Station, TXBuilt 1975 · S/N 17264755

Back to AD 87-20-03 R2