OpenAirDocs.org
AD 47-21-01

Registered aircraft · 105

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:47-21-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:47-21-01')
  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.

N18688Pfou Michael G · Princeton, MNBuilt 1939 · S/N W-101N23VWomack Jeffrey · Jackson, LABuilt 1946 · S/N W46-134N282FCClassic Toy Barn LLC · Central Islip, NYS/N R46261N4263SRobbins III James E · Lakeland, TNBuilt 1946 · S/N W46299N690FAParsons Donald L · Saint Peters, MOBuilt 1946 · S/N R46104N77602Leighton George E · Seattle, WABuilt 1946 · S/N W46302N77603Eastern Stearman Inc Trustee · Leesburg, VABuilt 1946 · S/N R46-303N77605Grossl Cameron L · Georgetown, KYBuilt 1946 · S/N W46-305N77607Potter Everett A P · Lansford, NDBuilt 1946 · S/N W46307N77609Tall Timber Flying Service LLC · Kalispell, MTBuilt 1946 · S/N W46309N77611Denzler Theodore A · Friendswood, TXBuilt 1946 · S/N R46311N77614K E F Enterprises Inc · Plymouth, MABuilt 1946 · S/N W46314N77618Schulert Philip J · Lebanon, TNBuilt 1946 · S/N W46-318N77630Barrong John M · Cottage Grove, ORBuilt 1946 · S/N W46330N77638Santorelly R · Glen Saint Mary, FLS/N W46-338N77654Hettenbach Paul A · Carrollton, TXBuilt 1947 · S/N R46333N77655Buntings Grassroots Aviation LLC · Selbyville, DEBuilt 1947 · S/N W46355N77656Ramos Richard E · Benicia, CABuilt 1947 · S/N W46356N77657Kahl William E · Syracuse, NYBuilt 1947 · S/N R46316N77659Patrick Matthew · Cincinnati, OHBuilt 1947 · S/N W46359N77660Plane Fun Inc Tr Trustee · Snellville, GABuilt 1946 · S/N R46-360N77661L & P Of Winona Inc · Winona, MNBuilt 1947 · S/N R46361N77665Dougherty James W Jr · Arlington, TXBuilt 1947 · S/N R46365N77667Smith Happy E · Rogersville, TNBuilt 1947 · S/N W46367N77671Ramos Richard E · Benicia, CABuilt 1946 · S/N R-46371N77672Demmel Ross · Tumwater, WAS/N R-46372N77681Grasso Vaughn L · Oak Hill, FLBuilt 1946 · S/N W46381N77682Stoos Robert A · Lakeland, FLS/N W46382N77686Harper Jack D · Jacksonville, FLS/N R46386N77688Short David J · Warrensburg, MOBuilt 1947 · S/N R46388N77691Hamilton Steven T · Carson City, NVBuilt 1947 · S/N R46391N77695Kipnis Inc · Wadsworth, ILS/N R46336N77696American Airpower Heritage Flying Museum · Dallas, TXBuilt 1947 · S/N R46337N77698Perez Philip G · Fort Worth, TXBuilt 1947 · S/N R46398N81201Avdeev Alexey · Purcellville, VABuilt 1946 · S/N W46102N81204Stone Craig J · Renton, WABuilt 1946 · S/N R46-105N81206Fulwiler Daniel R · Green Bay, WIBuilt 1946 · S/N W46107N81208Latimer Mark A · Roanoke, TXBuilt 1946 · S/N R46-109N81209Vecchiarelli Timothy J · Somers, CTBuilt 1946 · S/N W46110N81210Fairchild Argus LLC · Evergreen, COBuilt 1946 · S/N R46-111N81212Bartholomew Russell J · Albuquerque, NMBuilt 1946 · S/N R46113N81213Yanks Air Museum · Baldwin Park, CABuilt 1946 · S/N R46114N81214Letourneau Jaffe B · Olympia, WABuilt 1946 · S/N R46-115N81216Rockys Flying Service LLC · Wilmington, DEBuilt 1946 · S/N W46117N81222Keppen Charles J · Madison, SDBuilt 1946 · S/N W46123N81226Felda Flyers LLC · Felda, FLBuilt 1946 · S/N R46127N81228Hagerstown Aviation Museum Inc · Hagerstown, MDBuilt 1946 · S/N R46-129N81229Cassen Mark E · Wilson, WYBuilt 1946 · S/N W46130N81230Wyman Corwyn W · Columbia Falls, MTBuilt 1946 · S/N W46131N81234Haggerty John J Jr · Skaneateles, NYBuilt 1946 · S/N R46-135
Back to AD 47-21-01