Skip to content

AD 2007-04-19 R1

Registered aircraft · 108,428

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: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

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.

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

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.

N15105Sass Phillip A · Leavenworth, KSBuilt 1972 · S/N 28-7225591 N15106Chew Terrence G · Allyn, WABuilt 1972 · S/N 28-7305021 N15107Skahen Sean M · Saint Joseph, MNS/N 28-7305022 N1510SClark Lahn F · Pasco, WABuilt 1962 · S/N D-6940 N1510XSedlacek John · Pittstown, NJBuilt 1975 · S/N 28R-7535307 N1511Plane Fun LLC · Warrensburg, MOS/N 28R-31114 N15115Price Michael D · Shell Knob, MOBuilt 1972 · S/N 28-7305023 N15118Illinois Valley Flying Club Inc · Peru, ILBuilt 1972 · S/N 28R-7335023 N1511CBouton Vern H · Fairbanks, AKFirst renewal noticeBuilt 1953 · S/N 30211 N1511WFlorida Float Plane LLC · Coral Gables, FLBuilt 1972 · S/N TH-217 N15121Airborne Aviation LLC · Anchorage, AKFirst renewal noticeBuilt 1972 · S/N 28-7225589 N15122Dixson Joel T · Corpus Christi, TXBuilt 1972 · S/N 28-7225595 N15123Blackwood Aviation Services Inc · Orlando, FLBuilt 1972 · S/N 28-7305025 N15125Mallozzi Michael A · Albuquerque, NMBuilt 1972 · S/N 28R-7335025 N15126Registration Pending · Mc Caysville, GARegistration pendingBuilt 1972 · S/N 32-7300002 N1512CMolek Jon · Warren, OHBuilt 1953 · S/N 30212 N1512JHorning Timothy J · Saegertown, PABuilt 1967 · S/N 28-23906 N1512SIrwin Dennis R · San Diego, CABuilt 1962 · S/N D-6941 N1512WBryant John Mark · Knoxville, TNBuilt 1972 · S/N D-9332 N15132Lewis University · Romeoville, ILBuilt 1972 · S/N 28-7225597 N15133Brooks Cary H · Rosharon, TXBuilt 1977 · S/N 21800 N15134Roe Robert D Jr · Naples, FLBuilt 1972 · S/N 32-7300003 N1513CSteffen Thomas E · Decatur, TXBuilt 1953 · S/N 30213 N1513SHoward Michael G · Slaughters, KYBuilt 1962 · S/N CD-473 N1513TLagemann Jeffrey P · Cocoa, FLBuilt 1972 · S/N 32-7240128 N1513XTurner Gary H · Big Stone Gap, VABuilt 1975 · S/N 28-7505237 N15140Anthony J Cariotte Jr · Holbrook, NYBuilt 1972 · S/N 28-7225598 N15141Murphy Jeffrey S · Mechanicsburg, PABuilt 1972 · S/N 28-7305027 N15142Dj Aviation LLC · Rio Vista, TXS/N 28-7305028 N15145Tri-Star Aviation Inc · La Porte, TXBuilt 1972 · S/N 34-7350026 N15148Brown Jerry Keith · Calera, ALBuilt 1972 · S/N 28-7225599 N1514AMatthews Byron Kim · Hooper, UTS/N 20-703 N1514BLilu LLC · Siloam Springs, ARBuilt 1988 · S/N CE-1276 N1514JBooher Greg F · Livingston, TNBuilt 1967 · S/N 28-23908 N1514MVaquera Moises C · Orland, CABuilt 1975 · S/N 18264359 N1514TTucker David J · Welch, OKBuilt 1972 · S/N 28-7225539 N1514ZDierold Robert S · Carrollton, TXBuilt 1961 · S/N D-6832 N15151Smith Jared · Allendale, ILFirst renewal noticeBuilt 1972 · S/N 28R-7335029 N15152Meyer Kendra · Ankeny, IABuilt 1972 · S/N 28-7310015 N15153Kyzer Stacey A · Fort Mill, SCBuilt 1972 · S/N 28-7310016 N15159Piper One Five Niner Inc · Greenville, WIBuilt 1972 · S/N 28-7305029 N1515CMountain Taildraggers LLC · Aspen, COBuilt 1953 · S/N 30215 N1515FCain Ronald A · Slidell, TXBuilt 1965 · S/N 185-0844 N1515JMendenhall William R II · Beebe, ARS/N 28-23909 N1515MSurecraft LLC · Dover, DEBuilt 1988 · S/N CE-1304 N1515ROwen Ray M · Columbia Station, OHBuilt 1974 · S/N AA5B-0015 N1515TSussman Steven T · Goshen, NYBuilt 1972 · S/N 28R-7235311 N1515WCenturionair LLC · Greenville, SCBuilt 1972 · S/N TH-218 N1515ZYanks Air Museum · Baldwin Park, CABuilt 1961 · S/N D-6831 N15160Western Aire Flying Club Ltd · Sparta, WIBuilt 1972 · S/N 28-7305030

Back to AD 2007-04-19 R1