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.

N523MBJones Roy F · Benson, AZBuilt 1965 · S/N 310J0044N523MWJoy Of Flight LLC · Kalispell, MTBuilt 1967 · S/N 670013N523NDSunrise Aviation Inc · Ormond Beach, FLBuilt 2010 · S/N 172S11062N523PWbj Aviation LLC · Jackson, GAS/N E3853N523PUMetro Aircraft Co · Bloomington, MNBuilt 1989 · S/N 2841188N523QNixon John H · Ormond Beach, FLBuilt 1967 · S/N D-8582N523RCS W Air Travel Inc · Parshall, COBuilt 1975 · S/N 21060654N523SHNesher Wings LLC · Phoenix, AZBuilt 1998 · S/N EA-618N523SMFirst Owl Creek LLC · Aspen, COS/N 18280747N523TTennant Daniel R · Uniontown, OHBuilt 1963 · S/N D-7178N523TCSmith Ranch Bonanza LLC · San Francisco, CABuilt 1964 · S/N D-7613N523ZARegistration Pending · Perryton, TXRegistration pendingBuilt 1974 · S/N D-9596N52400Bluestem Acquisitions LLC · Fort Worth, TXBuilt 1973 · S/N 18262578N52402Sunny Aviation LLC · Kalispell, MTBuilt 1973 · S/N 18262580N52405Dorward Alan C · Shreveport, LABuilt 1973 · S/N 18262583N52406Prestige Aeronautics LLC · Haslett, MIFirst renewal noticeBuilt 1973 · S/N 18262584N52408Flory Jason E · Fremont, INBuilt 1980 · S/N 17274509N52409Cosner Dirk · Greeley, COBuilt 1973 · S/N 18262587N5240DBailey Carlton D Jr · Huntington, WVBuilt 1957 · S/N 50138N5240EWilson Brent A · Carmel, INBuilt 1978 · S/N 17271791N5240GBobbys Landing LLC · Pembroke Pines, FLBuilt 1951 · S/N 21349N5240PWeber Rodney D · Apple Valley, CABuilt 1958 · S/N 24-271N5240RRico Aviation Services Inc · Miami, FLBuilt 1974 · S/N 17263454N5240TRegistered aircraftBuilt 1972 · S/N 28-7225369N5240WVanni Steven J · Naples, FLBuilt 1962 · S/N 28-281N52415Pryor Stanley C · Indianapolis, INBuilt 1973 · S/N 18262591N52416Toepfer Stan L · Lanark, ILS/N 18262592N52417Eaton Roger C DBA · Vernon, NYBuilt 1980 · S/N 17274511N5241DSorbi Aviation Inc · El Cajon, CABuilt 1979 · S/N 17272465N5241EBaldeo Kessho I · Bay Shore, NYBuilt 1978 · S/N 17271792N5241JDuffys Aircraft Sales & Leasing Inc · Neillsville, WIBuilt 1980 · S/N 17273743N5241LFour One Lima Inc · Roanoke, VABuilt 1967 · S/N 28-4536N5241TWeiss Gregory K · Colorado Springs, COBuilt 1981 · S/N R18201840N52422Stevens Michael C · Kaysville, UTBuilt 1973 · S/N 18262597N52426Smtm Holdings Inc · Wilmington, DEBuilt 1980 · S/N 17274515N5242DR&R Aero Services LLC · Eden Prairie, MNBuilt 1979 · S/N 17272466N5242EWeeks Charles C · Setauket, NYBuilt 1959 · S/N 50542N5242GGray Eagle Farms LLC · Southampton, NJBuilt 1951 · S/N 22461N5242LSimpson Jacob William · Crescent Springs, KYBuilt 1967 · S/N 28-4537N5242PPennacchio Leo Trustee · Santa Rosa, CABuilt 1958 · S/N 24-273N5242RProctor Daniel L · Elkton, VABuilt 1974 · S/N 17263456N52430Beaudikofer Eric · El Centro, CABuilt 1973 · S/N 18262602N52431Lippian James Michael · New Boston, TXBuilt 1973 · S/N 18262603N52432Aftcloud Inc · Ontario, CABuilt 1980 · S/N 17274517N52436Angel Aviation Inc · Peoria, AZBuilt 1980 · S/N 17274520N52438Rick Aviation Inc · Newport News, VABuilt 1980 · S/N 17274522N5243DStoltzfus Sandra · Kidron, OHBuilt 1957 · S/N 50141N5243ECalifornia Professional Flyers Inc · Murrieta, CABuilt 1978 · S/N 17271793N5243LKeys Robert C · Winston Salem, NCBuilt 1967 · S/N 28-4538N5243PR & O Aviation LLC · Middleville, MIBuilt 1958 · S/N 24-274
Back to AD 2007-04-19 R1