Skip to content

Registered aircraft · 54,017

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.

N51136St Denis Matthew · Mountlake Terrace, WAFirst renewal noticeBuilt 1968 · S/N 15069787 N5113FVtf LLC · Winter Haven, FLBuilt 1965 · S/N 17252762 N5113KParrillo Development And Real Estate LLC · Sarasota, FLBuilt 1979 · S/N 17272455 N5113QTri-County Aviation LLC · Lawrenceburg, TNS/N 17261754 N51147Penn Mitchell · Poplar Bluff, MOBuilt 1968 · S/N 15069795 N5114DCasillas Justin M · Liberty, TXBuilt 1958 · S/N 51214 N5114EVinton John H · Mullen, NEBuilt 1959 · S/N 50414 N5114KParrillo Development And Real Estate LLC · Moorestown, NJBuilt 1980 · S/N 17273974 N5114QJ&A Air · Richfield, UTS/N 21059614 N5114USilverhawk Aviation Academy LLC · Caldwell, IDBuilt 1980 · S/N 172RG0243 N51156Knutson Wayne R · Tioga, NDS/N 15069801 N5115EBarak David T · Mountain Home, IDBuilt 1978 · S/N 17271717 N5115FSunrise Equipment Co · Canton, OHBuilt 1965 · S/N 17252776 N5115NFernandez Arriaga Emilio · Miami, FLBuilt 1980 · S/N 18267526 N51162Raia James · Vero Beach, FLS/N 15069805 N51165Detroit Public Schools Community District · Detroit, MIBuilt 1968 · S/N 15069808 N51167Cusick Christopher J · La Jolla, CABuilt 1968 · S/N 15069809 N51168Cherry Hill Aviation C182 LLC · Freetown, INBuilt 1968 · S/N 15069810 N5116ABatch Bryan A · Spokane, WABuilt 1955 · S/N 28116 N5116DRoche Patrick R · Wichita Falls, TXBuilt 1958 · S/N 51216 N5116FMancuso Donald R · Weatherford, TXBuilt 1965 · S/N 17252783 N5116JCarll Elizabeth M · Chicago, ILBuilt 1979 · S/N 17273707 N5116QAvolant Aviation LLC · Mooresville, NCBuilt 1981 · S/N 15285078 N51170Northern Sonic Alaska Inc · Fairbanks, AKBuilt 1968 · S/N 15069812 N51171Spruill William F · Wyoming, DEBuilt 1968 · S/N 15069813 N51174Tomah Flying Club Inc · Kendall, WIBuilt 1968 · S/N 15069815 N51177Mohiuddin Waqar S · The Woodlands, TXBuilt 1968 · S/N 15069818 N51178Tussey Mountain Flying Club LLC · State College, PABuilt 1980 · S/N 17274274 N5117ANorthwest Aircraft Maintenance LLC · Springdale, ARS/N 28117 N5117DAndre Kashierski · Estill Springs, TNBuilt 1958 · S/N 51217 N5117EJav Air Services LLC · Anchorage, AKBuilt 1978 · S/N 17271719 N5117G5117g LLC · Sandy, ORS/N 15065640 N5117QBush Thomas D Jr · Cypress, TXS/N 17261755 N5117TLevitan Sergei · Hollywood, FLBuilt 1981 · S/N R18201817 N51186Jones Stephen C · Wadsworth, ILBuilt 1968 · S/N 15069825 N51188Yuma Aero Services LLC · Yuma, AZBuilt 1968 · S/N 15069827 N51189Caufman Roger B · Loganville, GABuilt 1968 · S/N 15069828 N5118AQuinn Thomas P · Cherry Hill, NJBuilt 1955 · S/N 28118 N5118VGoldmark Charles J · Okanogan, WABuilt 1977 · S/N R1722278 N51195Martel Ian G · Proctorsville, VTBuilt 1968 · S/N 15069831 N51196Lienau Joseph E · Fish Creek, WIBuilt 1968 · S/N 15069832 N5119UClark Christopher F · Boise, IDBuilt 1964 · S/N 2060119 N5119XMission Aviation Fellowship · Nampa, IDBuilt 1980 · S/N U20605571 N5119YWby Aviation LLC · Lewes, DES/N 21064083 N511CWSydow Daniel P · Duluth, MNBuilt 1967 · S/N 18051859 N511DCJago River Holdings LLC · Fairbanks, AKBuilt 1966 · S/N U206-0543 N511EZiese And Grieshaber Consulting LLC · Catawba, NCBuilt 1959 · S/N 47107 N511GKAir Devices Company LLC · Alpena, MIBuilt 1978 · S/N 17270431 N511GMCrothall George · Oceanside, CABuilt 1968 · S/N 15069802 N511JBPlp Aircraft Classics LLC · Wilmington, DEBuilt 1978 · S/N 18503509

Back to AD 87-20-03 R2