Skip to content

Registered aircraft · 72,010

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.

N4145AUniverstiy Of Illinois · Savoy, ILBuilt 1998 · S/N 2843150 N4145GUniversity Of Illinois · Savoy, ILBuilt 1998 · S/N 2843151 N4145JDyka Samuel M · Flushing, MIBuilt 1966 · S/N 28-22469 N4145PBlackhawk Holding Corp · Wilmington, DEBuilt 1959 · S/N 23-1626 N4145VGrassroots Aviation LLC · Norfolk, NEBuilt 2000 · S/N 3246165 N4145XUniversity Of Illinois · Savoy, ILBuilt 1998 · S/N 2843152 N4145ZJma Aviation LLC · Pompano Beach, FLBuilt 1999 · S/N 3246142 N41468Boyer Daniel W · Carroll, OHBuilt 1974 · S/N 28R-7435188 N41469Shield Solutions LLC · West Plains, MOBuilt 2000 · S/N 3257154 N4146DBird Acquisition LLC · Phoenix, AZBuilt 1998 · S/N 2843153 N4146EHarrison Jeffrey L · Fairbanks, AKBuilt 1978 · S/N 18-7809085 N4146JJackson Billy B · Los Angeles, CABuilt 1966 · S/N 28-22470 N4146PN4146p Saratoga LLC · Austin, TXBuilt 1999 · S/N 3257106 N4146RUniversity Of Illinois · Savoy, ILBuilt 1998 · S/N 2843160 N4146TUniversity Of Illinois · Savoy, ILBuilt 1998 · S/N 2843168 N4146XOtt Dean R · Carrollton, OHBuilt 1968 · S/N 247 N41472Jeborah Aero LLC · Jefferson City, MOBuilt 1974 · S/N 28-7425245 N41474Indian Hills Community College · Ottumwa, IABuilt 1974 · S/N 28-7415229 N41477Shepro Scott M · Senoia, GABuilt 1974 · S/N 28-7405107 N4147EEnglerth Mark J · Wasilla, AKBuilt 1978 · S/N 18-7809086 N4147GStinson Aaron M · Anchorage, AKFirst renewal noticeBuilt 2000 · S/N 28-43364 N4147KUniversity Of Illinois · Savoy, ILBuilt 1998 · S/N 2843169 N4147NGeorge Robert J · Natick, MABuilt 1999 · S/N 3246131 N4147RRamos George L · Conroe, TXBuilt 1968 · S/N 32-40347 N4147TChandler Air Service Inc · Chandler, AZBuilt 1999 · S/N 2843272 N4147WRalls Michael Todd · Crawfordsville, IABuilt 1967 · S/N 32-40217 N4147YReisdorf Steven R · Saint Cloud, MNBuilt 1976 · S/N 956-76 N4147ZHopper Bruce · Chugiak, AKBuilt 1965 · S/N 18-8225 N41480Tradewind Aviation Co Inc · Blue Bell, PABuilt 1999 · S/N 3246147 N41482Cannella Ingrid D · Pineville, LABuilt 1974 · S/N 28-7415231 N41484Ferraro Jeffrey T · Mckinney, TXBuilt 1999 · S/N 4636234 N4148CMjolhus Knut G · Amarillo, TXBuilt 1978 · S/N R18200329 N4148DSkywest Leasing Inc · St George, UTBuilt 1998 · S/N 2843170 N4148EDoody Michael C · Knoxville, TNBuilt 1978 · S/N 18-7809087 N4148HRegistered aircraftBuilt 1978 · S/N 24-0647 N4148TChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 4496027 N4148YTailwheel Flying LLC · Rochester, MNBuilt 1976 · S/N 280-76 N4148ZWillet Gerald E · Townsend, MTBuilt 1965 · S/N 18-8227 N41492Charter Air Travel LLC · Mount Pleasant, SCBuilt 1999 · S/N 3257105 N41497Bagley Russell L · Frankston, TXBuilt 1974 · S/N 28-7425249 N41498G&M Aircraft Inc · Wheat Ridge, COBuilt 1974 · S/N 28-7415237 N4149ABoard Of Trustees · Savoy, ILBuilt 1998 · S/N 2843189 N4149CBoard Of Trustees · Savoy, ILBuilt 1998 · S/N 2843190 N4149GBoard Of Trustees · Savoy, ILBuilt 1998 · S/N 2843191 N4149JElko Aviation Group LLC · Elko, NVBuilt 1966 · S/N 28-22474 N4149RClary Daniela · Sunnyvale, TXBuilt 1999 · S/N 4636226 N4149TCrosswinds Flying Club Inc · Bloomington, ILBuilt 1998 · S/N 2843192 N414BCRoche Robert C · Casa Grande, AZBuilt 1965 · S/N 28-21129 N414DEdgewater Aviation LLC · Lake Havasu City, AZBuilt 1999 · S/N 460 N414DJSuper Tiger LLC · New York, NYBuilt 1979 · S/N AA5B1298

Back to AD 87-10-06 R1