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.

N8756MMutschler George R · Paradise Valley, AZS/N M-544 N8757MHolmes Charles E · South Bend, INBuilt 1963 · S/N M-545 N8758MAndrew Manuel Driscoll · South Yarmouth, MABuilt 1964 · S/N M-546 N875PDGarmin International Inc · Olathe, KSS/N E-3534 N875TMw Leasing Inc · Redlands, CABuilt 1965 · S/N D-7837 N8760MRegistration Pending · Cheney, WARegistration pendingS/N M-548 N8761MJohnson Gregory J · Port Orange, FLS/N M-549 N8763KNational Vietnam War Museum · Weatherford, TXBuilt 1957 · S/N BG-393(144086)N8763MHaugh Mervin E III · Red Lion, PABuilt 1965 · S/N M-802 N8766ABowden David A · Duncan, OKBuilt 1950 · S/N D-2202 N8769RPochwatka Patryk · Treasure Island, FLBuilt 1974 · S/N TC-1790 N876PMGeddie Steven Gwynn · College Station, TXBuilt 1976 · S/N E-961 N876THighrider LLC · Humble, TXBuilt 1965 · S/N D-7753 N87711Planeview Aviation Services Inc · Ahoskie, NCS/N BA-650 N8772RLevity Holdings LLC · Little Rock, ARBuilt 1974 · S/N TC-1795 N8773MSexton Jonathan B · Claremore, OKBuilt 1964 · S/N M-558 N8775MRio Aviation LLC · Wilmington, DES/N M-591 N8777RFluid Aviation LLC · Saint Clair, MIFirst renewal noticeBuilt 1974 · S/N P-291 N8778MSchroemer Theodore J · High Point, NCBuilt 1963 · S/N M-208 N877FBOverlander Aviation LLC · Palo Alto, CABuilt 1962 · S/N TC-298 N877HLLeavitt Randall Stephen Trustee · San Diego, CABuilt 1991 · S/N E-2643 N877SPElizabeth City State University · Elizabeth City, NCS/N ME-310 N877TSpecialty Paving Inc · Lincoln, CABuilt 2001 · S/N E-3381 N8780MTurner Michael T · Kernersville, NCS/N M-564 N87813Spence Michael D · Ruidoso, NMBuilt 1947 · S/N D-122R-14 N8781AFischer Dan · Houston, TXBuilt 1949 · S/N D-2186 N8782MZimpel Kurt S DBA · Hinckley, MNBuilt 1964 · S/N M-567 N8783AScott Roland E Jr · Baltimore, MDS/N D-2205 N8786ABloch Eden R · Riverside, CABuilt 1950 · S/N D-2208 N8787AGehling Kelly P · Fort Worth, TXBuilt 1950 · S/N D-2209 N8788Renken Jeremy L · Fairfax, VAS/N D-2778 N8789ASafrit Christopher · Midlothian, TXBuilt 1950 · S/N D-2211 N878BBarber Colman Co · Rockford, ILRegistration revokedBuilt 1956 · S/N D-4820 N878WMortgage And General Investment Corp · Big Bear Lake, CABuilt 2002 · S/N E-3459 N8792MWilkinson Larry E · Santa Rosa Beach, FLBuilt 1964 · S/N M-575 N8794AFramiglio John · Nashville, TNBuilt 1950 · S/N D-2216 N8795RPrice Ronald M Trustee · Bonita Springs, FLBuilt 1974 · S/N TC-1798 N8796AGregory Edward G Jr · Sparks, NVBuilt 1950 · S/N D-2218 N8796MRegistration Pending · Russell Springs, KYRegistration pendingBuilt 1964 · S/N M-579 N8796RSea2sky Aviation LLC · Dover, DEBuilt 1974 · S/N TC-1807 N8797RAirflyte LLC · Granby, CTBuilt 1974 · S/N TC-1812 N879MCJ P IV LLC · Hickory, NCBuilt 1977 · S/N D-10008 N87ARGalaxy Powersports & Automotive Inc · Warrington, PAS/N TG-67 N87DBBlanchat Manufacturing Inc · Harper, KSBuilt 1967 · S/N D-8570 N87DGLow Wing Aviation LLC · Mountain Home, ARBuilt 1959 · S/N D-5794 N87DPGo Pilot LLC · Orlando, FLBuilt 1964 · S/N TC-696 N87DUBdb Equipment LLC · Columbus, OHBuilt 1968 · S/N TE-662 N87JSLvyqt LLC · Menlo Park, CABuilt 1988 · S/N EA-476 N87KSockey Investments LLC · Poteau, OKBuilt 1964 · S/N D-7607 N87MTThompson John Stuart · Dallas, TXBuilt 1978 · S/N CE-771

Back to AD 99-05-13 R1 WD