Skip to content

Registered aircraft · 72,007

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-10-06-R1') 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-10-06-R1') 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-10-06-R1')
    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-10-06-R1')
  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-10-06-R1')
  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-10-06-R1')
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.

N2955MRls Rental Co DBA · Joplin, MOBuilt 1977 · S/N 28-7816326 N2955QAussieyank Air LLC · Reno, NVBuilt 1979 · S/N 28-7911265 N2955RSmith Billy V · Baton Rouge, LABuilt 1979 · S/N 28-7911266 N2955TFive Five Tango LLC · Rockford, ILBuilt 1979 · S/N 28-7911267 N29563Brown Winn D Jr · Horn Lake, MSBuilt 1968 · S/N 17700966 N2956AHuebner Dennis Andrew · Morgan Hill, CABuilt 1979 · S/N 28-7911269 N2956BFlorida Coatings & Waterproofing LLC · Fort Pierce, FLS/N 28-7911270 N2956CFlying The Fields LLC · Algonquin, ILBuilt 1979 · S/N 28-7911271 N2956LZembower Christopher L · Cumberland, MDBuilt 1967 · S/N 670090 N2956PVann Dudley Carroll · Greenville, NCBuilt 1979 · S/N 28-7916583 N2956RFlightline LLC · Summerville, SCBuilt 1979 · S/N 28-7990588 N2957Marrero Edgardo · Enterprise, ALBuilt 1971 · S/N 402 N2957FRichardson John Daniel · Madisonville, LABuilt 1979 · S/N 28-7911273 N2957LJohnson Cullen L · Abernathy, TXS/N 670091 N2957MJacobson Larry · Commack, NYBuilt 1979 · S/N 28-7911274 N2957NBak John A · Lake Forest, CABuilt 1979 · S/N 32-7940228 N2957PArwine James L · Waxahachie, TXBuilt 1955 · S/N 22-3230 N2957RBantle Aviation LLC · Midlothian, VABuilt 1979 · S/N 32-7940229 N29581Bas Part Sales LLC · Greeley, COBuilt 1968 · S/N 17700972 N29584Eagle Sky Patrol Inc · Deadwood, SDBuilt 1968 · S/N 17700974 N29585Ramold Corey M · Gretna, NEBuilt 1968 · S/N 17700975 N2958LStormo Jarrod M · Indianapolis, INBuilt 1967 · S/N 670092 N2958SSmith Jimmie A Trustee · Rose Hill, KSBuilt 1998 · S/N 23600 N2958XCooper Ronald C · Fowlerville, MIBuilt 1968 · S/N 17700358 N2958ZBryce Brad W · Lewis Center, OHBuilt 1959 · S/N 22-6931 N29592Reyner Matthew J · Georgetown, TXBuilt 1968 · S/N 17700978 N29593Else John J · Toledo, IABuilt 1968 · S/N 17700979 N29595Delta Fox Corp · Schaumburg, ILBuilt 1968 · S/N 17700980 N29596Murray Charles W · Reno, NVBuilt 1968 · S/N 17700981 N2959DWatson Frank H · Central Point, ORBuilt 1955 · S/N 26902 N2959LMcphillips Jess H · Port Arthur, TXBuilt 1967 · S/N 670093 N2959MHanneman Robert · Claremore, OKBuilt 1977 · S/N 28-7890281 N2959QParis Air Inc · Vero Beach, FLBuilt 1979 · S/N 28-7916585 N2959USmart5 LLC · Kissimmee, FLBuilt 1979 · S/N 28-7916588 N2959XCiochetti David · Kimberly, ORBuilt 1967 · S/N 17700359 N295ABFogerty Barry L · Shawnee, OKBuilt 2015 · S/N 23322 N295ACFanjoy James Michael · Nehalem, ORBuilt 1995 · S/N 756-95 N295BCWieler Jacob · Petty, TXS/N 28-7916435 N295BWWigglesworth Brad · Winnemucca, NVBuilt 1999 · S/N 3957 N295DAJackson Construction LLC · Charleston, SCBuilt 1968 · S/N 28-24582 N295GSStine Scott · Vincennes, INBuilt 2026 · S/N 763 N295JJElliott Jimmy F · Hesston, KSBuilt 2024 · S/N 92215 N295KQSemenske John · Singer, WIBuilt 2019 · S/N 91660 N295MAStanton David M Jr · Kiawah Island, SCBuilt 1995 · S/N 2811040 N295MEWings Air Charter LLC · Wisconsin Rapids, WIBuilt 2000 · S/N 172S8553 N295MRCarrera Air LLC · Tampa, FLBuilt 2005 · S/N 3257405 N295PCFleming Charles R · Merritt Island, FLBuilt 2003 · S/N 54864 N295RSBeisert Nikolas · Penn Valley, CABuilt 1992 · S/N 002RS N295RWMac IV Aeroworks LLC · Saint Petersburg, FLBuilt 2002 · S/N 56 N295SKds Aviation LLC · Normal, ILS/N 4636174

Back to AD 87-10-06 R1