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.

N182LRSouthwest American Woodworks LLC · Phoenix, AZBuilt 1965 · S/N 18256847 N182LVGloris Robert J · Lago Vista, TXBuilt 1973 · S/N 18262150 N182LWLoken Rodney R · Northwood, IABuilt 1972 · S/N 18261255 N182LXWave Aero Technology LLC · Rockledge, FLS/N 18262627 N182MService Oriented Aviation Readiness (Soar) · Bolivar, MOS/N 18255118 N182MBHeartland Airplanes LLC · Olathe, KSS/N 18264405 N182MFCoeur LLC · Coeur D Alene, IDBuilt 1973 · S/N 18262210 N182MJNelson Theresa H · Knoxville, TNBuilt 1979 · S/N R18200718 N182MKTruitt John H · Pittsburg, TXBuilt 1975 · S/N 18263541 N182MLDsr Cherokee 180 LLC · Dallas, TXBuilt 1966 · S/N 18256730 N182MMRacine Multisports LLC · Williamsport, MDBuilt 1980 · S/N 18267612 N182MPKelly Randolph H · Shelbyville, TNS/N 18259137 N182MRSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 18267642 N182MTBarley Daniel A · Camarillo, CAFirst renewal noticeBuilt 1982 · S/N 18268157 N182MYMiyazaki Yasutaka · Phoenix, AZBuilt 1966 · S/N 18257857 N182NHighly Favored One LLC · Las Vegas, NVBuilt 1971 · S/N 18260683 N182NABishop Trent Alan · Fremont, OHBuilt 1978 · S/N 18266612 N182NCKrizauskas David F · Moncks Corner, SCBuilt 1979 · S/N R182-01015 N182NHWingingitin LLC · Georgetown, INBuilt 1969 · S/N 18260148 N182NMKozy Mark A · Placerville, CABuilt 1975 · S/N 18263782 N182NPParker Nicholas S · Hailey, IDBuilt 1956 · S/N 33076 N182NRState Of Wisconsin · Madison, WIBuilt 1980 · S/N 18267535 N182NSJefferson Aircraft LLC · Metairie, LABuilt 1968 · S/N 18258888 N182PCPickens County Sheriffs Office · Pickens, SCBuilt 1977 · S/N 18265638 N182PDNk Dockside LLC · Escanaba, MIBuilt 1976 · S/N 18264775 N182PGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1978 · S/N 18266379 N182PLGonzales Edward · Gallup, NMS/N 18261723 N182PRWeigle Gerald V Jr Trustee · Cincinnati, OHBuilt 1972 · S/N 18261387 N182PSSso Aviation LLC · Gainesville, FLBuilt 1961 · S/N 18253524 N182PTMohawk Associates Inc · Wilmington, DES/N 18259948 N182PURdl Aviation LLC · Covington, GABuilt 1973 · S/N 18262689 N182PVGoble Robert G · Bellefontaine, OHBuilt 1975 · S/N 18263869 N182PWGarcia Jessica Paige · Magnolia, TXS/N 18267060 N182PXSeevers John A · Mccall, IDBuilt 1959 · S/N 51941 N182PZSix Nickles Aviation LLC · Macon, GABuilt 1975 · S/N 18264480 N182QWhitt Carson M · Deland, FLBuilt 1964 · S/N D-7646 N182QTKirkegaard Knud J · Cameron Park, CABuilt 1979 · S/N 18267039 N182RGerard Gary A · Litchfield Park, AZBuilt 1977 · S/N 18265604 N182RAHuckins Gregory L · Wichita, KSS/N 33743 N182RBMarkusic Michael L · Burlington, MIBuilt 1979 · S/N 18266989 N182RCWaddell Randy · The Villages, FLS/N 18267016 N182RETri-County Ag Service Inc · Ipswich, SDBuilt 1976 · S/N 18265074 N182RFBuman Donald A · Windsor, COBuilt 1966 · S/N 18257620 N182RJFarpointe Aviation LLC · Charleston, WVBuilt 1972 · S/N 18261514 N182RKJet Feeders LLC · Helena, OKBuilt 1977 · S/N 18265637 N182RLRichards Troy L · Krum, TXBuilt 1958 · S/N 51158 N182RMTruex T E · Georgetown, INBuilt 1966 · S/N 18257389 N182RNNensel Richard E · Sylvania, OHBuilt 1978 · S/N R18200311 N182RSGrumpy Petes Aviation LLC · Walla Walla, WAS/N 18264499 N182RWWissenbach Richard G · Pinesdale, MTBuilt 1960 · S/N 52702

Back to AD 98-21-21 R1