OpenAirDocs.org
AD 98-21-21 R1

Registered aircraft · 85,620

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:98-21-21-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:98-21-21-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.

N2012RPhysical Therapy And Sports Solutions LLC · Santa Fe, NMBuilt 1964 · S/N 18255212N2012S9791m LLC · Tacoma, WAS/N 21060980N2012WIron Compass LLC · Highland Park, MIBuilt 1965 · S/N D-7971N20132J & L Aviation LLC · Malta, NYBuilt 1972 · S/N 17261035N20133Creative Strategies Inc · Proctorville, OHBuilt 1972 · S/N 17261036N20136Crate Inc · Humboldt, NEBuilt 1972 · S/N 17261038N2013RZinsmeyer Charles D · Llano, TXBuilt 1964 · S/N 18255213N2013XEec Group LLC · Kalispell, MTBuilt 1965 · S/N 18256113N2013YRoberts Michael R · Plano, TXBuilt 1962 · S/N 17249513N2014Blue Skies Trading Company LLC · Toledo, OHS/N 18052338N20141Bbrrjd Inc · Wilmington, DEBuilt 1972 · S/N 17261042N20143Loomis Aviation LLC · Gahanna, OHBuilt 1972 · S/N 17261044N20148Baron 1-4-8 LLC · Merrimack, NHS/N TC-2159N2014EWanda Collins Professional Pilot Services LLC · Madisonville, TXBuilt 1978 · S/N 17271118N2014RDaedalus Wings Inc · Malvern, OHBuilt 1964 · S/N 18255214N2014UMlc Air LLC · Clarkston, MIS/N 24-1590N2014XTashjian Kirk G · Stanwood, WABuilt 1965 · S/N 18256114N20154Jones 170a LLC · Bridgman, MIBuilt 1972 · S/N 17261051N20155Wild Wingdom LLC · Greenville, SCBuilt 1972 · S/N 17261052N20157Kelley Aircraft LLC · Weyers Cave, VABuilt 1972 · S/N 17261053N20158Vbp Services LLC · Wainscott, NYBuilt 1972 · S/N 17261054N20159Western Edge Aviation LLC · Dickinson, NDBuilt 1972 · S/N 17261055N2015CMorgan Arrow LLC · Greeley, COBuilt 1978 · S/N E-1311N2015DAv8rs LLC · Portland, ORBuilt 1952 · S/N D-3366N2015RBennett Peter D · Birmingham, ALBuilt 1964 · S/N 18255215N2015T2015t LLC · Omaha, NEBuilt 1978 · S/N CE-795N2015VMangi Nitin · Hayward, CABuilt 1959 · S/N D-5760N2015WKrosswind Aviation LLC · Cape Coral, FLBuilt 1965 · S/N D-7975N2015XAircraft Trade Group LLC · Scandia, MNS/N 18256115N2015YHoing Randal H Jr · Mexia, TXBuilt 1962 · S/N 17249515N20162Wateractive43 LLC · Auburn, CABuilt 1974 · S/N 310Q-1004N20169R D T Aviation Inc · Williston, VTBuilt 1972 · S/N 17261062N2016CRavey Guy W · Virginia Beach, VABuilt 1978 · S/N TC-2175N2016DRbc Aero · Mooresville, NCBuilt 1966 · S/N D-8209N2016KAlp Paul · Falls Church, VABuilt 1978 · S/N TC-2163N2016NOsfly LLC · Wilmington, DEBuilt 1978 · S/N E-1313N2016RCoburn William L · Snohomish, WAS/N 18255216N2016XSmith James A · Lyle, WAS/N 18256116N2016Y2016y LLC · Aurora, COBuilt 1978 · S/N D-10157N20172Queen City Aero Club Inc · Chelmsford, MABuilt 1972 · S/N 17261065N20175Jet Air Solutions Inc · Fort Myers, FLS/N 17261068N20176Greenwood David L · Garrettsville, OHBuilt 1972 · S/N 17261069N20177Nashville Flight School LLC · Nashville, TNBuilt 1972 · S/N 17261070N20178Christopher Sandra A · Mabel, MNBuilt 1972 · S/N 17261071N2017DCream Puff Classics Inc · Hubertus, WIBuilt 1952 · S/N D-3368N2017GZolezzi Paul A · Cottage Grove, ORS/N 51317N2017PBruninga Harold J · Jacksonville, ILBuilt 1978 · S/N D-10156N2017WDucharme Paul Quin · Lafayette, LABuilt 1965 · S/N TE-12N2017XJensen Timothy L · Hudson, WIBuilt 1965 · S/N 18256117N20181Mile High Aviation · Saint Peter, MNBuilt 1972 · S/N 17261074
Back to AD 98-21-21 R1