AD 91-21-01 R1

Registered aircraft · 5,086

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:91-21-01-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:91-21-01-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.

N9284X84x Leasing LLC · Idaho Falls, IDBuilt 1997 · S/N 4636087N9285QJrb Aviation Ltd · Jasper, GABuilt 1997 · S/N 3257023N92884Bas Part Sales LLC · Greeley, COBuilt 1997 · S/N 4636107N9288PLivingston Jerry D · Wichita, KSBuilt 1968 · S/N 24-4788N9289PSvetlik Ludvik Julius · Victoria, TXS/N 24-4789N928HLJ & M Sales & Leasing LLC · Abingdon, ILS/N T20608066N9292NN9292n LLC · Valdosta, GABuilt 1997 · S/N 3257008N9292PRegistered aircraftBuilt 1968 · S/N 24-4791N9292YWeisend Chad M · Logansport, INBuilt 1969 · S/N 31-387N9293PCenterline Holdings Inc · Camden, DEBuilt 1968 · S/N 24-4792N9293YBecker Ryan · Sheldon, IABuilt 1985 · S/N 32R-8629004N9294PJensen Thomas · Durango, COBuilt 1968 · S/N 24-4793N9295GMcavian LLC · Westworth Village, TXBuilt 1997 · S/N 3257017N9296NSunrider Aviation Inc · Irvine, CABuilt 1997 · S/N 3257013N9296PStevens John W · Westlake Village, CABuilt 1968 · S/N 24-4795N9297P9797p LLC · San Angelo, TXBuilt 1968 · S/N 24-4796N9298DAims Air LLC · Kingsport, TNBuilt 1997 · S/N 3257002N9299PFusion Flight Management LLC · Lake Havasu City, AZBuilt 1997 · S/N 4636123N9299XSchoepel Alexandra E Trustee · Templeton, CABuilt 1997 · S/N 3257021N929DJA And S Flying Services Inc · Bristol, VABuilt 2004 · S/N 3257344N929RRPanafax LLC · Wilmington, DEBuilt 1997 · S/N 4636115N92BLIsland Birds Inc · St Thomas, VIS/N 31-7852095N92DMD & M Flyers LLC · Petoskey, MIBuilt 1978 · S/N 27-7854107N92ECStevens Faustin R · Kennewick, WABuilt 1977 · S/N 32R-7880007N92EJSecond Life Properties LLC · Salisbury, MDBuilt 1978 · S/N 32R-7885242N92GTBlue Skies Aviation LLC · Riverdale, MDBuilt 2002 · S/N 2100N92HDN242ak LLC · Ocala, FLBuilt 2003 · S/N 3257326N92HRSweetsholdings LLC · Lewisville, TXBuilt 1970 · S/N 31-649N92JWKennedy Donald R Jr · New Philadelphia, OHBuilt 1974 · S/N E600N92LLTanner Dave · Auburn, CABuilt 2000 · S/N 3257191N9303PDyster Justin C · Coeur D Alene, IDBuilt 1968 · S/N 24-4799N930KGGriggs Roger · Columbia, SCS/N 32R-8029027N930MDTab Associates Inc DBA · Port Saint Lucie, FLBuilt 1967 · S/N 27-3787N930ZMirage 930 Corp Trustee · Wilmington, DEBuilt 1995 · S/N 4622188N9312PGregory John P · Riverside, CABuilt 1969 · S/N 24-4808N9313PPencosky Edward A Jr · Manorville, NYBuilt 1969 · S/N 24-4809N9315PGrady Michael J · Farmington, NMBuilt 1969 · S/N 24-4811N9316PProvost Stephen Nicholas · Saint Louis, MOBuilt 1969 · S/N 24-4812N9317PFutter John H · Whately, MABuilt 1969 · S/N 24-4813N9318PPorter Wayne · Phoenix, AZBuilt 1969 · S/N 24-4814N931SAMarc Inc · Bolton, MSBuilt 1975 · S/N 317552036N9321PRegistered aircraftBuilt 1969 · S/N 24-4818N9325PCody William James · South Lyon, MIBuilt 1969 · S/N 24-4822N9327PKrb LLC · Rupert, IDBuilt 1969 · S/N 24-4825N9329PLenders Insurance Solutions Group LLC · Ozark, MOBuilt 1969 · S/N 24-4827N9331PAmra Nabil · Chaska, MNS/N 24-4829N9333PSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1969 · S/N 24-4831N9338PDream Home Aviation Inc · New Smyrna Beach, FLS/N 24-4836N9339PBreznik John D · Bradford, PABuilt 1969 · S/N 24-4837N9342PTaulbee Gregory · Sarasota, FLBuilt 1969 · S/N 24-4840
Back to AD 91-21-01 R1