Registered aircraft · 13,518

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:99-05-13-R1-WD') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD') 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:99-05-13-R1-WD')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD')
  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:99-05-13-R1-WD')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD')
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.

N4376WSmith Ryan · Canby, ORBuilt 1974 · S/N D-9626 N4377GD&P Enterprises Inc · Fresno, CABuilt 1985 · S/N TJ-479 N437EMagic Shuttle Bus Air Tours LLC · Traverse City, MIBuilt 1966 · S/N D-8179 N437PCantrell William Taylor Jr · Richmond, VAS/N CE-1045 N4384WPacific Media Properties Inc · Santa Ana, CABuilt 1974 · S/N E-536 N4388WNiezen Henry J · San Luis Obispo, CABuilt 1974 · S/N D-9600 N438GMRye Air LLC · Grimes, IABuilt 2000 · S/N E-3353 N438TBluhm Raymond M · Waxhaw, NCBuilt 1971 · S/N D-9256 N43927Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1945 · S/N A-26 N4393AOgilvie Terry Michael · Loveland, COBuilt 1970 · S/N CE-300 N439RRRandel Ron L · Greeley, COBuilt 1958 · S/N D-5389 N43ABV Tail Flyers Llp · South Lyon, MIBuilt 1959 · S/N D-5838 N43AMBrown Randy A · Placerville, CABuilt 1964 · S/N TD-572 N43ATOld Virginia Properties LLC · Cedar Bluff, VABuilt 1965 · S/N TC-881 N43BBHilyer Bruce W · Camano Island, WABuilt 1990 · S/N CE-1517 N43DBMuller Michael C · Peachtree City, GABuilt 1968 · S/N TE-617 N43HDEastern Shore Aviation LLC · Lebanon, PAFirst renewal noticeBuilt 1970 · S/N P-149 N43KEInternational Air Services Inc Trustee · Carson City, NVBuilt 1988 · S/N EA-484 N43KTTowles Michael D · Corona Del Mar, CABuilt 1993 · S/N E-2808 N43LVLight & Variable Lp · Las Vegas, NVS/N E3546 N43MCRed Mountain Express Care LLC · Queen Creek, AZBuilt 1970 · S/N TG-85 N43QCAviation LLC · Kalispell, MTBuilt 1984 · S/N TJ-467 N43RQChristman George Myron · Amsterdam, NYBuilt 1977 · S/N CE-716 N43YIsbell Edwin Chad · Spring, TXBuilt 1974 · S/N E-576 N44007Parrish Rob G · Columbus, TXBuilt 1953 · S/N G-126 N4405AJohnson Marvin E · Garfield, WABuilt 1970 · S/N D-9141 N4405DTorea Alex C · Hastings On Hudson, NYBuilt 1956 · S/N D-4519 N4407DLessley Aviation LLC · Carrollton, MSBuilt 1956 · S/N D-4537 N4408DMurphy Michael L · Sylvia, KSBuilt 1956 · S/N D-4554 N440CKKeirs Christopher D · Tomball, TXBuilt 1964 · S/N TC-736 N440CP929 Aviation LLC · Shreveport, LABuilt 1975 · S/N P-373 N440DDeeble Kenneth M · Dayton, MTBuilt 1964 · S/N D-7461 N440GVon Pasecky Ronald · Gilbert, AZBuilt 1976 · S/N D-9911 N440LAParks David W · Ithaca, NYBuilt 1957 · S/N D-5257 N440LLLast Larry A · Oshkosh, WIBuilt 1979 · S/N M-2208 N440QB&T Aviation LLC · Columbia, SCBuilt 1964 · S/N D-7410 N440RMann Robert F · Oshkosh, WIBuilt 1983 · S/N MC-793 N440SUFutrell Kenneth R · New Smyrna Beach, FLBuilt 1977 · S/N E-1115 N440TJs Aviation Group LLC · Sedona, AZBuilt 1976 · S/N CE-681 N4410DHunt James W · Maryville, TNBuilt 1956 · S/N D-4572 N4417SPlanes Of Fame Air Museum · Chino, CABuilt 1944 · S/N 6918 N4417WReyling Joseph E · Glasgow, MTBuilt 1974 · S/N E-529 N4418ABorchert Pete · Prescott, AZBuilt 1970 · S/N D-9142 N4418DRam Air Inc · Presque Isle, MIBuilt 1956 · S/N D-4545 N4419AMccants Robley D · Mesa, AZS/N D-9147 N4419DSzostak Edward M · San Diego, CABuilt 1956 · S/N D-4558 N441MCBemidji Aviation Services Inc · Bemidji, MNS/N LF 45 N441WCMoore Jeremy Emmett · Baton Rouge, LABuilt 1978 · S/N TC-2181 N441WW4kd Corporation · Wilmington, DEBuilt 1975 · S/N CE-606 N4420DEyre Matthew R · Prescott, AZBuilt 1956 · S/N D-4592

Back to AD 99-05-13 R1 WD