Registered aircraft · 13,518

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-05-13-R1-WD') 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-05-13-R1-WD') 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-05-13-R1-WD')
    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-05-13-R1-WD')
  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-05-13-R1-WD')
  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-05-13-R1-WD')
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.

N708WAltitude Aviation LLC · Missoula, MTBuilt 1985 · S/N E2269 N7096NBoylan Scott J · BerlinBuilt 1967 · S/N D-8662 N709JDBond John D · Prosper, TXBuilt 1979 · S/N E-1503 N709MAZephyrus Flyers LLC · Carson City, NVBuilt 1984 · S/N E-2117 N709RMJci Marketing And Consulting LLC · Wilmington, DEBuilt 1975 · S/N TC-1863 N709TMitchell Marcinda Personal Representative · Sallisaw, OKBuilt 1978 · S/N E-1284 N70DRLanzillo Joseph H · Lancaster, PABuilt 1979 · S/N D-10224 N70DSArmstrong Harold E · Houston, TXBuilt 1976 · S/N CE-683 N70DWEastern Flatlanders LLC · Yuma, COBuilt 1964 · S/N D-7705 N70EERoot Shane G · Dighton, KSFirst renewal noticeBuilt 1966 · S/N TE-13 N70GAbj Holdings LLC · Buckeye, AZBuilt 1973 · S/N TC-1540 N70GAAmerican Airpower Heritage Flying Museum Inc · Dallas, TXBuilt 1966 · S/N A-177 N70HCCamp John S · Los Gatos, CABuilt 1998 · S/N E-3172 N70KTLucarelli Jeffrey M · Summerville, SCFirst renewal noticeBuilt 1953 · S/N D-3480 N70MBCastro Gary Clinton · Visalia, CABuilt 1968 · S/N TC-1193 N70MEAmsdell David A · Morgantown, WVBuilt 1978 · S/N D-10123 N70MFMoyer Aviation Inc · Tobyhanna, PABuilt 1962 · S/N TC-382 N70MVDawson Asset Management And Consulting LLC · Edgartown, MABuilt 1979 · S/N D-10222 N70PGAmerican Skyteam LLC · Floral Park, NYBuilt 1991 · S/N CE-1635 N70RAMarabella John · Sarasota, FLBuilt 1965 · S/N D-7819 N70SLMcleod Sammy Dale Jr · Spring, TXBuilt 1986 · S/N EA-459 N70SSJones Terry L · Danville, VABuilt 1966 · S/N D-8024 N70TBPauly Martin · Cedar Rapids, IABuilt 1978 · S/N E1289 N70TPBlack Eagle Aviation LLC · Livonia, MIBuilt 1987 · S/N CE-1153 N70WWIsland City Seaplanes Inc · Cordova, AKFirst renewal noticeS/N A-38 N7102NDefelice David E · Ponte Vedra Beach, FLBuilt 1967 · S/N D-8667 N7104NGober Kerwin D · Farmington, NMBuilt 1967 · S/N D-8666 N7109NDerendal Justin · Peoria, AZBuilt 1967 · S/N TE-489 N710ABAf-Aviation LLC · Miami, FLBuilt 1976 · S/N E-823 N710AMQualitair LLC Trustee · MichelstadtBuilt 1953 · S/N D-3587 N710DRGo 2 Guys Inc · Fresno, CABuilt 1966 · S/N TC-986 N710PAMartin Frank S · Overton, NVS/N P-152 N710VMartin James D · Graford, TXBuilt 1959 · S/N D-6135 N7114NPrairie Air Inc · Elbow Lake, MNBuilt 1967 · S/N D-8668 N7116NMook Joshua Tyler · Cincinnati, OHBuilt 1967 · S/N D-8670 N7117EDowell Cameron C · Solomons, MDBuilt 1974 · S/N MC-278 N7118Mace Paul B · Ashland, ORBuilt 1957 · S/N D-5099 N711AAPro-Star Aeronautical Inc · Morrison, COBuilt 1977 · S/N P-417 N711AMNixon Bruce C · Portales, NMBuilt 1979 · S/N E-1487 N711ARFlying Burrito LLC · Placerville, CABuilt 1982 · S/N EA-284 N711BStoner Brian · Puryear, TNBuilt 1948 · S/N D-1716 N711CMPonderosa Aviation LLC · Safford, AZS/N TC-171 N711CUR C Graham Inc · Wichita Falls, TXFirst renewal noticeBuilt 1967 · S/N TG-35 N711DJPatenaude Steven J · Livermore, CABuilt 1952 · S/N D-3059 N711GSSouth Delta Aviation Inc · West Helena, ARBuilt 1971 · S/N CE-333 N711HPUhlig Paul Nelson · Wichita, KSBuilt 1978 · S/N TC-2127 N711HRMarshall Phillip W III · Enid, OKBuilt 1974 · S/N E-519 N711KMRegistration Pending · Cologne, MNRegistration pendingBuilt 1970 · S/N D-9106 N711LBSale Reported · Brunswick, GASale reportedS/N D-1695 N711LWWhelchel Leon · Vinton, IABuilt 1962 · S/N D-6984

Back to AD 99-05-13 R1 WD