OpenAirDocs.org
AD 99-05-13 R1 WD

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
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.

N138ADDance Carlton Spencer · Center, TXBuilt 1991 · S/N CE-1638N138GGardiner Alan H · Waterford, CTBuilt 1964 · S/N D-7564N138PBSouth Delta Aviation Inc · West Helena, ARBuilt 1980 · S/N TJ-273N138PLCpg Air LLC · Skaneateles, NYBuilt 1986 · S/N TJ-482N138QKyff Jeffrey V · Traverse City, MIBuilt 1964 · S/N TC-612N138TOnderko George C · Fairmont, WVBuilt 1950 · S/N D-2566N138TLHarvest International Ministries Inc · Texarkana, ARBuilt 1981 · S/N TJ-362N138TWSulka Andrew Mark · Pittsburgh, PABuilt 1974 · S/N D-9647N1390ZGm Aviation LLC · Woodridge, ILBuilt 1961 · S/N D-6833N1392ZRautiola Charles A · Rosemount, MNBuilt 1961 · S/N D-6822N1393ZSdd LLC · Great Falls, MTBuilt 1961 · S/N D-6813N1396AEsser J Randolph Trustee · Birmingham, ALBuilt 1969 · S/N D-9012N1397ZJ&W Air LLC · Asheville, NCBuilt 1961 · S/N D-6819N139PTCroley John T Jr · Fitzgerald, GABuilt 1964 · S/N TC-758N139QMoles Timothy E · New Cumberland, WVBuilt 1964 · S/N TC-638N139ROlsen David A · Marinette, WIBuilt 1978 · S/N D-10083N139TATell Christopher A · Colville, WABuilt 1974 · S/N D-9652N13ARKeen Daniel Edward · Peoria, AZBuilt 1954 · S/N D-3885N13BLCross Country Aviation LLC · Park City, UTBuilt 1975 · S/N E-724N13EGo Leasing Co · Phillipsburg, KSBuilt 1952 · S/N D-3259N13EJAvidash LLC · Cape Coral, FLS/N CE1130N13HMN13hm LLC · Punta Gorda, FLBuilt 1970 · S/N TE-813N13JCVintage Flying Museum Inc · Fort Worth, TXBuilt 1954 · S/N BA-31N13JGJones Eric M · Keller, TXBuilt 1953 · S/N G-297N13MKLjh Consulting Services LLC · Greenleaf, IDBuilt 1968 · S/N TE-515N13PECamm Air · Spencer, IAS/N TJ-50N13PNWillis Ted A · Fayetteville, ARBuilt 1957 · S/N D-5231N13RKSwartz Charles Harris Jr · Spicewood, TXBuilt 1978 · S/N E-1238N13RTWoodhouse Dave · Battle Creek, MIBuilt 1962 · S/N D-6954N13TLittle Texan LLC · Brighton, MIS/N G-79N13VMAhs Aero LLC · Phoenix, AZBuilt 1975 · S/N CE-552N13WBRodgers Harold Lynn Jr · Mckinney, TXBuilt 1956 · S/N BG-145N13XXNantz William G Jr · Raleigh, NCS/N D-6467N13YZCreative Destination Development LLC · Mount Pleasant, TXBuilt 1976 · S/N E-859N13ZZTigerair Of Alabama Inc · Newark, DEBuilt 1973 · S/N E-464N1400EDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1956 · S/N BA-227N1400GRotor Spec Aviation LLC · Star, IDBuilt 1961 · S/N D-6890N1402LRaskin Michael · Henderson, NVBuilt 1965 · S/N M-791N1403G1403g LLC · Wheat Ridge, COBuilt 1961 · S/N TC-227N1404GJkc Farm LLC · Chinook, MTBuilt 1961 · S/N D-6893N1405GLefever Larry R · Fall City, WABuilt 1961 · S/N D-6891N1406LBrainerd Philip S · Lake Placid, FLBuilt 1965 · S/N M-795N1408GMorris Travis T · Chandler, AZBuilt 1961 · S/N D-6892N1409GAir Care Leasing LLC · Lamar, COBuilt 1961 · S/N TC-233N1409LMusketeer Flying Club LLC · Plano, TXBuilt 1965 · S/N M-798N140KBMcclendon Dan · Burleson, TXBuilt 1979 · S/N EA 36N140UCJackson Donald R · Lexington Park, MDBuilt 1951 · S/N D-2822N140WLMorning Air LLC · Indian Rocks Beach, FLBuilt 1979 · S/N TC-2231N1412GBruch Lance J · Emmetsburg, IABuilt 1961 · S/N D-6895N14147Pugsley Len · East Wenatchee, WABuilt 1952 · S/N D-3145
Back to AD 99-05-13 R1 WD