Skip to content

Registered aircraft · 22,428

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-08-08-R3') 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-08-08-R3') 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-08-08-R3')
    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-08-08-R3')
  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-08-08-R3')
  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-08-08-R3')
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.

N141WAJohnston James E · Fernandina Beach, FLBuilt 1980 · S/N 28-8116135 N1422XDt'S Aviation LLC · Garden City, KSBuilt 1975 · S/N 28-7525287 N1423TWaggoner Kevin M · Donnellson, IABuilt 1972 · S/N 28-7225509 N1423XFigueroa Rafael A Jr · Coulterville, CABuilt 1975 · S/N 28-7515317 N1424MFly High LLC · Mobile, ALBuilt 1973 · S/N 32-7300043 N1424TFoster Adam J · Houston, TXBuilt 1972 · S/N 28-7225511 N1424XLewis Keith W · Clearwater, FLBuilt 1975 · S/N 28-7515318 N1425TSkydance Aviation LLC · Norfolk, VABuilt 1972 · S/N 28R-7235286 N1425XHowell Joshua · El Cajon, CABuilt 1975 · S/N 28-7515319 N1426THillcrest Of Central Fl LLC · Auburndale, FLBuilt 1972 · S/N 32-7200038 N1426XBair Preston W Jr · Coshocton, OHBuilt 1975 · S/N 28-7515321 N1427XAlis Aquilae LLC · Opelika, ALBuilt 1975 · S/N 28-7515402 N1428JLeedham James E DBA · Mazeppa, MNBuilt 1966 · S/N 28-3539 N1429XRegistered aircraftBuilt 1975 · S/N 28R-7535278 N142ASGray William Colin · Seattle, WABuilt 1966 · S/N 28-22530 N142FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLBuilt 1982 · S/N 28-8290177 N142MHAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1973 · S/N 28R-7335230 N142MSPlane Fun Inc Tr Trustee · Snellville, GAS/N 28R-8331017 N142NDSkyblue Aviation Cr Inc · Merritt Island, FLBuilt 1989 · S/N 2841229 N142TVPaulson Douglas W · Miami, FLBuilt 1979 · S/N 28R8031020 N1430XRuggiero Matthew J · New York, NYBuilt 1975 · S/N 28R-7535279 N1432TSmith David · Belleville, ILBuilt 1972 · S/N 28-7205296 N1433TTilton Dave P · Bradyville, TNS/N 28R-7235287 N1433XEchota Flyers Inc · Calhoun, GAS/N 28-7515406 N1434TStrickland Jason · Gulfport, FLBuilt 1972 · S/N 28R-7235288 N1435TWaters Nicholas T · Claypool, INBuilt 1972 · S/N 32-7240121 N1437HFry Dennis Charles · Anaheim, CAS/N 32R-7780160 N1437TBenazzi Wahiba · Frisco, TXS/N 28-7225514 N1439XDovy Aviation LLC · Houston, TXBuilt 1975 · S/N 28-7525301 N143BSMoses Charles · West Friendship, MDBuilt 1966 · S/N 28-3792 N143DWCardinal Aviation LLC · Towson, MDBuilt 1974 · S/N 32-7440164 N143EYTriple D Aviation LLC · Merritt Island, FLBuilt 1968 · S/N 28-24348 N143FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLBuilt 1982 · S/N 28-8290178 N143JMMa Cedric Sek-Kong · Los Angeles, CABuilt 1964 · S/N 28-20358 N143PBHemdmm Corp · Wilmington, DEBuilt 1977 · S/N 28R-7703243 N143TBSmith Timothy T · Turkey, NCBuilt 1979 · S/N 28-8011053 N1440UPiper Aircraft Inc · Vero Beach, FLBuilt 2025 · S/N 28020248 N1442TKeller Mark · Alexandria, KYBuilt 1972 · S/N 28-7205298 N1444XWaddell Charles · Elk Grove, CABuilt 1975 · S/N 28R-7535283 N1445HNelson Joshua M · Eagle, IDBuilt 1999 · S/N 3257092 N1445TWhelan And Sons Realty LLC · Suffield, CTBuilt 1972 · S/N 28R-7235290 N1446XN15956 Inc · Wilmington, DEBuilt 1975 · S/N 28-7525317 N1447HMarkovich David E · Eden Prairie, MNBuilt 1977 · S/N 28-7725144 N1447TDa Silva Paulo E · Orlando, FLS/N 28R-7235292 N1447XGaventa Edward J · Logan Twp, NJBuilt 1975 · S/N 28-7525318 N1448XMallett Robert T · Wilmington, MABuilt 1975 · S/N 28-7505229 N144AMStardust Aviation LLC · Farmingdale, NYBuilt 2021 · S/N 28020016 N144CTCti Aircraft Leasing LLC · Memphis, TNS/N 2881298 N144EZFlorida Aviation LLC · Tallahassee, FLS/N 32R-7885184 N144MC450 Dancer LLC · Benton Harbor, MIBuilt 1967 · S/N 28-22804

Back to AD 87-08-08 R3