AD 94-05-05 R1

Registered aircraft · 26,230

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:94-05-05-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:94-05-05-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.

N872FTeachout Caleb · Chesterfield, MIBuilt 1946 · S/N 9057N872KBBruner Kevin G · Vandalia, OHBuilt 1946 · S/N 11220N87304Mackie Kevin S · Longview, WABuilt 1946 · S/N 477N87308Cato James W · Las Cruces, NMS/N 481N8730SDederer Laura · Valencia, PAS/N 15062030N8730UKachalsky Alan N · Rye, NYBuilt 1976 · S/N 15077975N87312Lademann Ryan C · Saint Clair Shores, MIBuilt 1946 · S/N 485N8731GCard James D · Mc Cool, MSBuilt 1966 · S/N 15062831N8731SLawrenz Richard A · Mcpherson, KSS/N 15062031N8731USemet Marva S · Seattle, WABuilt 1976 · S/N 15077976N87321Wiger Theodore L · Falcon Heights, MNS/N 494N87323Cardwell Gregory D · Cameron Park, CABuilt 1946 · S/N 489N8732GPerkins Robert A · New Richmond, WIBuilt 1966 · S/N 15062832N8732UHumke John D · Eufaula, OKS/N 17252636N87330Maison Taisiya E · Olney, MDBuilt 1946 · S/N 503N87336Abreu David A · Del Rio, TXBuilt 1946 · S/N 509N87340Eleazer Robert W III · Merritt Island, FLBuilt 1946 · S/N 513N87346Bryson Stephen Mark · Corsicana, TXBuilt 1946 · S/N 519N87348Howard Dale L · Harrisburg, NCBuilt 1946 · S/N 521N8734UGrow Aviation LLC · Aurora, NEBuilt 1965 · S/N 17252638N87359Manning Gary · Newalla, OKBuilt 1946 · S/N 532N8735UJkh Aviation LLC · Cumming, GABuilt 1965 · S/N 17252639N8736BCampbell Jack G · Spring Valley, WIBuilt 1957 · S/N 36436N8736GSantana Amaury · Winter Haven, FLBuilt 1966 · S/N 15062836N8736UC & M Aviation Holdings LLC · Brockport, NYBuilt 1965 · S/N 17252640N87374Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 547N8737BFranklin Rodney S · Burns, ORBuilt 1957 · S/N 36437N8737UMiss Lou Flight LLC · Vidalia, LABuilt 1965 · S/N 17252641N8738URhk Of Kansas · Jefferson City, MOBuilt 1976 · S/N 15077977N87391Specht Leo M · Towner, COS/N 564N8739GKlott William D · Morris, ILBuilt 1966 · S/N 15062839N8739HShaw Brian W · Bemidji, MNBuilt 1960 · S/N 7EC-729N8739UAndrews Willard R · Windham, MEBuilt 1965 · S/N 17252643N873XJOnken Richard · Hastings, NEBuilt 2006 · S/N 65563N87405Specht Leo M · Towner, COBuilt 1946 · S/N 578N8740BOltrogge Construction Inc · Absarokee, MTBuilt 1957 · S/N 36440N8740SBucks Flight Academy LLC · Cashion, OKS/N 15062040N87410Harpole Bill · Dickinson, NDBuilt 1946 · S/N 583N87416Amann David Paul · Wesley Chapel, FLBuilt 1946 · S/N 589N8741BPhoenix Air Inc · Orland Park, ILBuilt 1957 · S/N 36441N8741GDahlberg James C · Ogilvie, MNS/N 15062841N8741SJohnson Zachary R · Burien, WABuilt 1965 · S/N 15062041N8741USexton Mathew G · Rockwell City, IABuilt 1965 · S/N 17252645N87426Safety-Net LLC · Salem, INS/N 599N8742BTexas Wings LLC · San Antonio, TXBuilt 1957 · S/N 36442N8742GReeve Howard E · Minot, NDS/N 15062842N8742UJennings Jeff L · Kenly, NCS/N 17252646N87433Four Five Air LLC · Traverse City, MIBuilt 1946 · S/N 606N87435Owen Nick F · Jacksboro, TXBuilt 1946 · S/N 608N87449Korzelius Matthew J · Niagara Falls, NYBuilt 1946 · S/N 622
Back to AD 94-05-05 R1