OpenAirDocs.org
AD 2018-03-03 R1

Registered aircraft · 1,770

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:2018-03-03-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:2018-03-03-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.

N188DFArc Holdings LLC · Grand Junction, IABuilt 1984 · S/N 425-0188N188GWBrown Die Casting & Manufacturing Inc · Royse City, TXBuilt 1979 · S/N 421C0613N189MKS2ar Aviations LLC · Lantana, FLBuilt 1978 · S/N 414A0100N18EGBoanco Inc · Lafayette, INBuilt 1973 · S/N 414-0394N18TN18t Ltd · Wilmington, DEBuilt 1968 · S/N 421-0144N18TCAviotti Inc · Henderson, NVBuilt 1978 · S/N 421C0503N1905B605 Aviation LLC · Aberdeen, SDBuilt 1978 · S/N 414A0214N1919LSmith Sydney O · Lithonia, GAS/N 411-0157N1925GEfi Technology Inc · Cave Creek, AZBuilt 1975 · S/N 421B0826N192AFWarren E Mack LLC · Minneapolis, MNBuilt 1980 · S/N 414A0496N1942GBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 421B0842N1944GBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 421B0844N1946GPartwin421 LLC · Greenwich, CTBuilt 1974 · S/N 421B0846N196CAHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0116N196FSTechnical Education Services Inc · Virginia Beach, VABuilt 1978 · S/N 421C0501N1987GPhillips Michael M · Angleton, TXBuilt 1974 · S/N 414-0544N1995GHarris Justin R · Hico, TXBuilt 1974 · S/N 414-0602N19STS&S Aviation Co · Ball Ground, GAS/N 414A0452N1GQAero Attack Systems (USA) Inc · Blaine, WANon-citizen corporation, flight hours not reportedBuilt 1972 · S/N 421B0236N1QMAhlhorn Travis W · New Braunfels, TXBuilt 1979 · S/N 421C0701N1YASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1974 · S/N 421B0580N200BNRubber Duck Aviation LLC · Brunswick, GABuilt 1980 · S/N 421C0881N200DCBjg Aviation I LLC · Neelyville, MOBuilt 1981 · S/N 421C1223N200EKBw Air LLC · Pierre, SDBuilt 1984 · S/N 425-0205N200MCN200mc Inc Trustee · Cheyenne, WYBuilt 1973 · S/N 414-0424N200TNI & V Aviation LLC · Missoula, MTBuilt 1978 · S/N 421C0444N202AASimply Living LLC · Fort Myers, FLBuilt 1980 · S/N 421C1015N202DBClipper Air LLC · Cresson, TXBuilt 1978 · S/N 421C0488N202SWMar Jar LLC · Gilmer, TXBuilt 1980 · S/N 414A0515N202ZLojas Phillip · San Ysidro, CAS/N 411-0292N203JLJfra LLC · Miami, FLBuilt 1981 · S/N 414A0670N205CAHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0207N207RS5m Consulting LLC · Uvalde, TXBuilt 1984 · S/N 4250195N208VBas Part Sales LLC · Greeley, COBuilt 1975 · S/N 421B0866N209DCDelaware Corp · Topping, VABuilt 1979 · S/N 414A0229N20HKGill John H · Woodway, TXS/N 414A0088N20MWStriebel David J · Dayton, OHBuilt 1975 · S/N 421B0918N20WAOn Air Company LLC · Sewickley, PAS/N 414A0280N210FCBaked Industries Inc · Yuba City, CABuilt 1975 · S/N 421B0908N212RVMinuteman 12 LLC · Wilmington, DES/N 421C0684N214CCSteele Aviation LLC · Tuscaloosa, ALS/N 421C0670N214DFGaylord Hangars LLC · Gaylord, MIBuilt 1973 · S/N 421B0461N215MPPersson Timothy J · Kansas City, KSS/N 421C1231N216LBBail Air LLC · Port Saint Lucie, FLBuilt 1974 · S/N 414-0545N21GFBas Part Sales LLC · Greeley, COBuilt 1971 · S/N 421B-0209N21KDMrd Aviation LLC · Windsor, COBuilt 1979 · S/N 414A0439N21SGTwo One Sierra Golf LLC · Seattle, WABuilt 1976 · S/N 421C0039N21SSMidwest Corporate Air Inc · Bellefontaine, OHBuilt 1978 · S/N 421C0473N21WUDallas Aero & Sales LLC · Poplar, MTBuilt 1979 · S/N 421C0650N220GDJoseph M De Lecce Trustee · Prather, CAS/N 414A0459
Back to AD 2018-03-03 R1