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.

N15JUC&D Aviation LLC · Appleton, WIBuilt 1982 · S/N TJ-434 N15KCGostanian Gregory K · Fresno, CAS/N D-3478 N15LSArch Air LLC · Paducah, KYBuilt 1972 · S/N TC-1465 N15MCAir Heritage Inc · Beaver Falls, PABuilt 1956 · S/N BG-295 N15PCollins Jeffery S · Griffin, GABuilt 1956 · S/N DH-92 N15PHBindon Phil E · Wasilla, AKFirst renewal noticeBuilt 1958 · S/N RLH-20 N15PMDodson International Parts Inc · Rantoul, KSBuilt 1977 · S/N E-1016 N15RDWood Richard W Trustee · Oroville, CABuilt 1978 · S/N E-1407 N15RPKnob Creek Aviation LLC · Oak Ridge, LABuilt 1974 · S/N E-539 N15TTray Aircraft Leasing LLC · Port Richey, FLBuilt 1964 · S/N TC-626 N15TDRegistration Pending · Chicago, ILRegistration pendingBuilt 1973 · S/N P-232 N15USale Reported · Van Nuys, CASale reportedBuilt 1979 · S/N ME-160 N15VMGagne Jay A · Dyersburg, TNBuilt 1976 · S/N D-9936 N15XLrb Aviation LLC · Catawba, NCBuilt 1979 · S/N TJ-226 N15XAMenigoz Michael Steven · Puyallup, WABuilt 1975 · S/N E-732 N15XLN15xl LLC · Conway, ARBuilt 1977 · S/N TC-2048 N160Niemyjski Justin S · Franksville, WIBuilt 1943 · S/N 4836 N1600GBrown David · Bell Buckle, TNBuilt 1959 · S/N DH-211 N1601WSix Ten Ventures LLC · Grand Prairie, TXBuilt 1972 · S/N D-9360 N1606WParagon Airplane Leasing Co · Fort Myers, FLBuilt 1972 · S/N TC-1467 N160LTodd Victor E · London Mills, ILBuilt 1958 · S/N DH-201 N160SPAerospace Trust Management LLC Trustee · Wilmington, DES/N D-9615 N160UCrane Rental Service Inc · Tempe, AZBuilt 1960 · S/N CJ-9 N1619WExecutive Aircraft Management LLC · Northport, ALBuilt 1972 · S/N TE-869 N161ABSafford Aviation Service Inc · Coolidge, AZBuilt 1977 · S/N TJ-122 N161KWalker John D · Neosho, MOBuilt 1943 · S/N 4821 N161KCCk Aviation LLC · Melbourne, ARBuilt 1980 · S/N E-1700 N161RBower Fredrick S · Watervliet, MIS/N TE-365 N161TRRambo Timothy B · Nampa, IDBuilt 1991 · S/N CE-1619 N161TSDoege Jackson B · Dallas, TXS/N E-3519 N161WCater Christopher B · Lowell, MIBuilt 1965 · S/N D-7914 N1621WColeman Alan · Tyler, TXBuilt 1972 · S/N TC-1455 N1622WN83993 LLC · Cherry Hill, NJExpired dealer, pending cancellationBuilt 1972 · S/N TE-870 N1624WHill Travis · Smithville, TXBuilt 1972 · S/N CE-384 N1625WGunter Professional Pilot Services LLC · Wichita Falls, TXBuilt 1972 · S/N D-9365 N1628WT W Air LLC · Worthington, KYS/N D-9366 N162BLMid South Aviation Inc · New Orleans, LAS/N E-2263 N162DFFaford Aviation Leasing Co · Atherton, CABuilt 1982 · S/N TJ-403 N162NBorgen Brian K · Osage Beach, MOBuilt 1966 · S/N TE-154 N1632WCdg Aviation LLC · Cresson, TXBuilt 1972 · S/N D-9363 N1634WTaglieri Ronald F · Pass Christian, MSBuilt 1972 · S/N D-9378 N1635WTullos Hugh S III · Oklahoma City, OKBuilt 1972 · S/N E-350 N163GCBartholomew Terry L · Pavilion, NYBuilt 1973 · S/N M-1469 N163QGofly Trading LLC · Opa Locka, FLBuilt 1964 · S/N TC-671 N163SPAgriflite Services Inc · Wakarusa, INBuilt 1972 · S/N TE-872 N1642WFreeport Supply Co · Wyandotte, MIBuilt 1972 · S/N P-198 N1643EYoung Michael T · Flower Mound, TXBuilt 1992 · S/N CE1643 N16444Harris Steven L · Sisters, ORBuilt 1936 · S/N 103 N164BPlummer Keith G · Tishomingo, OKBuilt 1955 · S/N D-4437 N164DAAv Beech Holding LLC · Mandeville, LABuilt 1966 · S/N MA-101

Back to AD 99-05-13 R1 WD