AD 2007-04-19 R1

Registered aircraft · 108,434

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:2007-04-19-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:2007-04-19-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.

N282PHMission Padamo Aviation And Support Inc · Luray, VABuilt 1980 · S/N U20606068N282RTenere Ventures LLC · Wilmington, DEBuilt 1981 · S/N CE-951N282RCCardwell Ronald L · Littleton, COBuilt 2024 · S/N 83463N282RDRonneberg Devin H · Molalla, ORBuilt 1993 · S/N 282N282RFDevault Michael E · Fairmont, WVBuilt 1968 · S/N 18259466N282SHBubs Leasing LLC · West Des Moines, IABuilt 2005 · S/N 2105N282TWLake Of The Woods Aviation LLC · Baudette, MNBuilt 1977 · S/N 18265943N282VKelly Michael J · Overgaard, AZBuilt 1999 · S/N 3676N28301Breault John L III · Los Angeles, CABuilt 1977 · S/N AA5B0440N28302Larson Barry S · Loomis, CABuilt 1977 · S/N AA5B0539N28303Elshire Vance M · Newberry, FLS/N AA5B0540N28304Conard Isaac J · Overland Park, KSBuilt 1977 · S/N AA5B0541N28306Tiger Flyers Inc · Santa Monica, CABuilt 1977 · S/N AA5B0550N28307Dfix LLC · Parker, COS/N AA5B0551N28309Hesoun Jeffrey J · Surgoinsville, TNBuilt 1977 · S/N AA5B0553N2830AMarathon Heater Inc · Del Rio, TXBuilt 1970 · S/N E-201N2830JPagano Nathan J · New Haven, CTBuilt 1979 · S/N 28-7916456N2830PSandpiper Aviation LLC · Wilmington, DEBuilt 1998 · S/N 17280593N2830QRetro Modern Aviation LLC · Manitou Springs, COBuilt 1971 · S/N 17259830N2830RCae Flying Club Of Ohio · Toledo, OHBuilt 1967 · S/N 18258430N2830TThree Zero Tango Corporation · Wentzville, MOBuilt 1972 · S/N 28-7205229N2830XCollins Stanley T · Elizabethtown, KYBuilt 1967 · S/N 17700230N28316Rmp LLC · Pocatello, IDS/N AA5B0558N2831GJohnston Skippy W · Fairbanks, AKBuilt 1967 · S/N 57N2831KBjorkman Glenn A · Goleta, CABuilt 1979 · S/N 18053092N2831TMesiemore Roger · Lake Wylie, SCBuilt 1972 · S/N 28R-7235141N28320James Allan L · Eloy, AZBuilt 1977 · S/N AA5B0559N28328Plein Lindsay E · Wrightwood, CABuilt 1977 · S/N AA5B0562N2832MCronin Terrance F · Federal Way, WABuilt 1977 · S/N 28-7816316N2832RMabe Bradley L · Cascade, IDBuilt 1967 · S/N 18258432N2832TKirtland Air Force Base Aero Club · Kirtland Afb, NMBuilt 1972 · S/N 28R-7235142N28330Neumayer Barry A · Redlands, CABuilt 1977 · S/N AA5B0563N28331Samoskevich Stephen A · Trumbull, CTBuilt 1977 · S/N AA5B0564N28335Vance Marc G · Canal Winchester, OHS/N AA5B0567N28336Kittenplan Alex H · Millbury, MABuilt 1977 · S/N AA5B0568N28338Registered aircraftBuilt 1977 · S/N AA5B0569N28339St Laurence Perry N · La Mesa, CABuilt 1977 · S/N AA5B0570N2833AMamuzich Robert J DBA · Deming, NMS/N 30033N2833CKizer Charlene A · Albany, ORBuilt 1978 · S/N R18200234N2833DScott Glen H · Spring, TXBuilt 1979 · S/N 28-7916451N2833FWeaver Arnold G · Sandusky, MIBuilt 1979 · S/N 28-7916452N2833NLansing Community College · Mason, MIBuilt 1979 · S/N 28-7916453N2833RRegistered aircraftS/N 18258433N2833YLancaster Mark E · Buffalo, SCBuilt 1962 · S/N 18253833N2833ZVaughn James F · La Porte, INS/N 22-6828N28345Avivus LLC · Austin, TXBuilt 1977 · S/N AA5B0575N28347Adriatic Holdings LLC · Cheyenne, WYBuilt 1977 · S/N AA5B0576N2834ADalton John B · Dallas, ORBuilt 1953 · S/N 30034N2834BSager Arthur · Joseph, ORBuilt 1979 · S/N 28-7990477N2834COsborne David A · San Antonio, TXBuilt 1978 · S/N R18200235
Back to AD 2007-04-19 R1