Registered aircraft · 4,001

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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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.

N187Molina Luis J · Broken Arrow, OKBuilt 1975 · S/N P3370208 N1871MHickam James R · Dayton, WABuilt 1973 · S/N 33701471 N1872MRenforth Michael · Yorktown, VAS/N 33701472 N1873MAsmus Edward W III · Sugar Grove, ILBuilt 1973 · S/N 33701473 N1876VRedding Aero Enterprises Inc · Redding, CABuilt 1976 · S/N R1722217 N1880MPalm Hammock II LLC · Zolfo Springs, FLS/N 33701480 N1880VKdn Aviation LLC · Annapolis, MDBuilt 1976 · S/N R1722218 N1881MBrutlag Farms Inc · Wendell, MNBuilt 1973 · S/N 33701481 N189Jones William Cody · Roxton, TXS/N P3370209 N1890MPutney Bruce N · Midlothian, TXS/N 33701490 N1896SSky Dds LLC · Las Vegas, NVBuilt 1998 · S/N 3449088 N189MLStrobe Aviation LLC · Columbia, SCBuilt 1977 · S/N 34-7770114 N18BBMuseum Of Flight Foundation · Seattle, WAFirst renewal noticeBuilt 1967 · S/N 337M0069 N18EFWade William G · Unity, MEBuilt 1954 · S/N 154 192 N18JLKlapmeier Alan · Iron River, WIBuilt 1974 · S/N P337-0165 N18NSGilberto Alfonso · Washington, NCBuilt 1978 · S/N R1723066 N18RKJacksonville Twin Comanche LLC · Kalispell, MTFirst renewal noticeBuilt 1979 · S/N 34-7970151 N18TPPotter Todd J · Warrens, WIBuilt 1979 · S/N 34-7970431 N1909FMarshal Group LLC · Lucedale, MSBuilt 1964 · S/N P17257189 N190CDMontague Paul N III · Vancouver, WABuilt 2000 · S/N 1099 N190FTWestchester Flying Club Inc · Purchase, NYBuilt 1978 · S/N 28R-7837245 N191BWSung Properties LLC · Visalia, CABuilt 2005 · S/N 1577 N191CDInzerillo Richard C · West Coxsackie, NYBuilt 2000 · S/N 1100 N191LNSrr LLC · Central Lake, MIBuilt 2005 · S/N 1548 N1925JBuzco Aviation LLC · Thomaston, GABuilt 1966 · S/N 337-0431 N192CWBowen Jeffrey Charles · Frankston, TXBuilt 1979 · S/N R1723092 N192TMWalker Randy · De Queen, ARBuilt 2005 · S/N 1578 N193RJWannebo Edward H · Henderson, NVBuilt 1980 · S/N R1723315 N193WTHovland Patrick John · Munster, INBuilt 2002 · S/N 1165 N1946VLeading Edge Aviation Inc · Doylestown, PABuilt 1976 · S/N R1722221 N194SHStipe Robert N · Rawlins, WYBuilt 1979 · S/N 25-0270 N1952HAmpersand Air Inc · Camp Hill, PABuilt 1977 · S/N 28R-7703041 N1952MLatimore Company LLC · Snohomish, WABuilt 1975 · S/N 33701665 N1956DPeyton Patrick J · Manorville, NYBuilt 1956 · S/N 191-229 N195CDGemini Aviation LLC · Brownsburg, INBuilt 2000 · S/N 1089 N1968AChristopher Chester F · Bay Saint Louis, MSBuilt 1973 · S/N M3370129 N1970FSkymaster Stc LLC · Mena, ARBuilt 1969 · S/N 33701243 N1980HEf Aviation LLC · Cape Coral, FLS/N 28R-7703044 N1987HFour C Sons Inc · Kersey, COBuilt 1977 · S/N 28R-7703046 N1989HHogan Thomas J · San Diego, CABuilt 1977 · S/N 34-7770164 N198CMOff Rock Aviation LLC · Lewes, DEBuilt 1981 · S/N 34-8133250 N198PSDorsing Kevin G · Othello, WABuilt 1998 · S/N 3449051 N198TBHonore Breen Aviation LLC · Allegan, MIBuilt 1980 · S/N 348070032 N1991LHarvatine Francis J · Sykesville, MDBuilt 1976 · S/N MC-431 N1997HScarry Daniel · San Luis Obispo, CABuilt 1977 · S/N 28R-7703047 N199PDCity Of Sacramento · Sacramento, CABuilt 1979 · S/N R1723127 N19AXAircraft Ownership Solutions LLC · Kokomo, INBuilt 1981 · S/N 25-0504 N19BAgricultural Investors LLC · Jacksonville, FLBuilt 1977 · S/N 34-7770293 N19EZAir Mobile Ministries · Sneedville, TNBuilt 1970 · S/N 33701315 N19FGAchtel Stephen E · Delavan, WIBuilt 1972 · S/N 139

Back to AD 81-13-10 R1