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

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

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.

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

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.

N1459MK And L Aviation Incorporated · Wilmington, DEBuilt 1969 · S/N U20601459 N1459VRegistration Pending · Portsmouth, NHRegistration pendingBuilt 1974 · S/N 17263596 N1459YBriere Mark E · Mims, FLBuilt 1962 · S/N 17249159 N145AAMuharsky Walter A Jr · Wilmington, NCS/N 28R-8131170 N145ARPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010047 N145BCassels James M · Checotah, OKBuilt 1973 · S/N 74-32-133 N145DDemaray Russell N · Sedona, AZBuilt 1980 · S/N TC-2348 N145JKArcus Aero LLC · Bridgeport, TXBuilt 1965 · S/N 18051549 N145JMA&K Aviation LLC · Lambertville, MIBuilt 1980 · S/N D-10334 N145LYQuarter To Two Flying Club Inc · Williamsport, PABuilt 2000 · S/N 28-43335 N145MTilley Steven E · Biddeford, MEBuilt 1977 · S/N D10061 N145MLKuonen Christopher · Wellsboro, PABuilt 1976 · S/N 17268382 N145PPainter Bryan J · Renton, WABuilt 1963 · S/N 205-0332 N145PLState Of Alaska · Anchorage, AKBuilt 1981 · S/N U20606141 N145SWShore Gerry · Inez, TXBuilt 1973 · S/N 310Q-0614 N145TSBonanza A36 LLC · Wildwood, MOBuilt 1999 · S/N E-3235 N145WWWings Over Texas Holdings LLC · Denton, TXBuilt 2002 · S/N 4496145 N145XBaron 55 LLC · Hutchinson, MNBuilt 1963 · S/N TC-507 N1460FConrad William A · Freedom, WIBuilt 1966 · S/N 17254955 N1460PBas Part Sales LLC · Greeley, COS/N 23-523 N1460VCk Leasing Services LLC · Wilmington, DES/N 17263597 N1460XSimpson Arthur Lee · Richland Center, WIBuilt 1975 · S/N 28-7525293 N1461EOracle Aviation LLC · Omaha, NEBuilt 1978 · S/N 17271009 N1461HJohnson Kent W · Clemons, IAS/N 28-7790313 N1461TNiepert William · Jacksonville, NCBuilt 1972 · S/N 28-7225522 N1461UKettle Peter · Fitchburg, MABuilt 1976 · S/N 17267128 N1461YKarpov Vladimir · Raymond, NES/N 17249161 N1462DWarner Aric D · Rosamond, CAS/N 20045 N1462FLambdin Charles Randall · Wolf Lake, ILBuilt 1966 · S/N 17254957 N1462SRiverside Aviation LLC · Oakland, IABuilt 1976 · S/N 18265009 N1462TWilliams Lesley J · Marquette, MIBuilt 1972 · S/N 28-7225523 N1462XVerbsky Douglas Collins · Frisco, TXBuilt 1975 · S/N 28-7525300 N1463DSorrell Edward S · Vero Beach, FLBuilt 1951 · S/N 20046 N1463E1463 Echo LLC · Eau Claire, WIS/N 17271010 N1463HPrickett John M · Manchaca, TXS/N 28R-7703026 N1463TN1463t LLC · Oak Hill, VABuilt 1972 · S/N 28-7225529 N1464ERegistration Pending · New Windsor, NYRegistration pendingBuilt 1978 · S/N 17271011 N1464GClauson Edward Ptrust · Charlestown, RIBuilt 1962 · S/N CD-468 N1464SRauch Andrew J · Timnath, COBuilt 1976 · S/N 18265011 N1464TSiedentopf Zyurelaie Indiana · Yelm, WABuilt 1972 · S/N 28-7205302 N1464XSymmetry Inc · Sarasota, FLBuilt 1975 · S/N 28-7515410 N1465DHendrickson Elisabeth · Kerrick, MNBuilt 1951 · S/N 20080 N1465EDandelion Wine LLC · Charleston, SCBuilt 1978 · S/N 17271012 N1465HHolland Ray A · Blue Earth, MNS/N 28-7710002 N1465MBig Mountain Construction LLC · La Grande, ORBuilt 1969 · S/N U20601465 N1465TCaudle Tommie A · Bentonville, ARBuilt 1972 · S/N 32-7200040 N14661Badenhope John R · Greeneville, TNS/N D-2978 N1466FGoody Birds LLC · Prattville, ALBuilt 1979 · S/N 17273005 N1466MTabor Shayne · Renville, MNBuilt 1970 · S/N U20601466 N1466SCombs Brent L · Dallas, SDBuilt 1976 · S/N 18265013

Back to AD 98-21-21 R1