Skip to content

Registered aircraft · 10,639

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:99-01-05-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:99-01-05-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:99-01-05-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:99-01-05-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:99-01-05-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:99-01-05-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.

N2918MGuess Gerald Bryan · Hernando, FLS/N 12-1419 N2918PLafferty Eric M · Anchorage, AKBuilt 1955 · S/N 22-3186 N2918ZLarson David R · Boerne, TXS/N 22-6888 N2919MPiccione Joseph A · Washington, NJBuilt 1946 · S/N 12-1427 N2919ZPankonin Steve B · White City, ORS/N 22-6889 N2920MLaney Charles A · Maiden, NCBuilt 1946 · S/N 12-1326 N2920PErwin Randall · Johnson City, TNBuilt 1955 · S/N 22-3188 N2920ZBruch Robert Allen · Roanoke, VABuilt 1959 · S/N 22-6890 N2922MAdkins Clifton R · Woodstock, ILBuilt 1946 · S/N 12-1446 N2923MCunningham David M · Eagle River, AKBuilt 1946 · S/N 12-1429 N2923PEckelbarger George R · Zanesville, OHBuilt 1955 · S/N 22-3191 N2925MBedgar Dean Jr · Lexington Park, MDBuilt 1946 · S/N 12-1428 N2927ZDensmore Jerry L · Rapid City, SDBuilt 1959 · S/N 22-6898 N2929MSale Reported · Casa Grande, AZSale reported, pending cancellationBuilt 1946 · S/N 12-1331 N2929TTampa Bay Flying Club Corp · Tampa, FLS/N 22-9630 N2930MYoung Timothy T · Wasilla, AKBuilt 1946 · S/N 12-1332 N2933MAllen Glenn · Landenberg, PABuilt 1946 · S/N 12-1439 N2934MConrad Donald C · De Pere, WIBuilt 1946 · S/N 12-1447 N2935ZTittle James L · Pembine, WIBuilt 1959 · S/N 22-6907 N2936MHoward Brian M · Boise, IDBuilt 1946 · S/N 12-1448 N2936ZSzostak Edward M · San Diego, CABuilt 1959 · S/N 22-6908 N2937PSmith Caleb · Wasilla, AKBuilt 1955 · S/N 22-3206 N2939ZWozniak Robert Frank Jr · Sparrows Point, MDBuilt 1959 · S/N 22-6911 N293THenderson Donald G · Bedford, INS/N 18-2407 N2941PWeddle Curtis Eugene · Iowa Park, TXBuilt 1955 · S/N 22-3210 N2942MClark John T · Elbert, COBuilt 1947 · S/N 12-1337 N2942ZHolloway Johnnie M · Laurel Hill, NCBuilt 1959 · S/N 22-6914 N2943MWidman Eric J · Palmer, AKBuilt 1946 · S/N 12-1336 N2943PDriscoll Patrick J · Caldwell, IDBuilt 1955 · S/N 22-3212 N2945MGilliland John R · Cantwell, AKBuilt 1946 · S/N 12-1344 N2946PClassic Aircraft LLC · South Bend, INBuilt 1955 · S/N 22-3216 N2947PWhite Hat Repair LLC · Greenleaf, IDBuilt 1955 · S/N 22-3219 N2948PMurdock Seth A · Dayton, WAS/N 22-3220 N294TVan Wagner Aerial Media LLC · Hollywood, FLS/N 182408 N2950ZLand Olin Franklin Jr · Baton Rouge, LABuilt 1959 · S/N 22-6923 N2951MStallone Anthony D · Anchorage, AKBuilt 1945 · S/N 12-1346 N2951ZToscano Bruce A · Colfax, WABuilt 1959 · S/N 22-6924 N2952MBrown Ben · Kasilof, AKBuilt 1946 · S/N 12-1347 N2952PTrue Carl B · Avalon, CABuilt 1955 · S/N 22-3224 N2953MFawcett Walter L Jr · Wolfeboro, NHBuilt 1946 · S/N 12-1348 N2953ZEverette John H · Garner, NCBuilt 1959 · S/N 22-6926 N2954ZBarkley Terry W · Lakeside, ORBuilt 1959 · S/N 22-6927 N2957DLuke Ted T · Twentynine Palms, CAS/N 12-1350 N2957PArwine James L · Waxahachie, TXBuilt 1955 · S/N 22-3230 N2958ZBryce Brad W · Lewis Center, OHBuilt 1959 · S/N 22-6931 N295THendrickson Elisabeth A · Kerrick, MNBuilt 1953 · S/N 18-2409 N2960PBrown Daniel A · Gettysburg, PABuilt 1955 · S/N 22-3233 N2960ZHuff Justin · Central, SCS/N 22-6934 N2961Wilbanks Kevin W · Artesia, NMBuilt 1972 · S/N 188967 N2961MMuth Robert F · Whitefish, MTS/N 12-1354

Back to AD 99-01-05 R1