Registered aircraft · 72,010

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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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.

N4818LFischer Denise L · Lake View Terrace, CABuilt 1967 · S/N 28-4158 N4819GVeer Aviation Tx LLC · Houston, TXBuilt 1979 · S/N 17273367 N4819TJacob Rolando V · Las Vegas, NVBuilt 1972 · S/N 28-7205201 N481AArcher Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 2843747 N481ACVogel Lawrence O · Gig Harbor, WAS/N 1289-2000 N481DMEdgewood Capital LLC · Joplin, MOBuilt 2001 · S/N 1307-2001 N481EMClark Jeffrey V · Libertyville, ILBuilt 1996 · S/N 375-96 N481GSSchmidt Grant S · Jamestown, NDBuilt 1973 · S/N 28-7325622 N481JLWolfco Timber Services LLC · Lebanon, ORBuilt 2017 · S/N JA1607094 N481MASlavens Timothy W · Howard City, MIBuilt 2003 · S/N 441-2003 N481TCFargo Aviators LLC · Phoenix, AZBuilt 2002 · S/N T18208184 N481WPoper Jeremy · Albuquerque, NMBuilt 2005 · S/N T18208362 N481WSBoer John W · Okeechobee, FLBuilt 2013 · S/N 71940 N481XCMarino Jerry C II · San Francisco, CABuilt 2012 · S/N 111 N48205Popinko Charles D · Obrien, FLBuilt 1977 · S/N DEC-2 N4820DBledsoe Duane C · Glendale, AZBuilt 1979 · S/N 17272369 N4820FS&S Aviation Plus LLC · Greenville, ILBuilt 1976 · S/N 28-7790062 N4820GAckerman Garry · Plano, TXBuilt 1979 · S/N 17273368 N4820LFick Paul R · Deansboro, NYBuilt 1967 · S/N 28-4160 N4820SCalico Construction Inc · Kensington, MDBuilt 1979 · S/N R18201432 N4821AMeyer James D · Cheney, KSBuilt 1956 · S/N 22-3974 N4821FOestreich Klaus M · Needville, TXBuilt 1976 · S/N 28-7790063 N4821LFlying Rocks LLC · Sparkill, NYBuilt 1967 · S/N 28-4162 N4821S4821s LLC · Ponte Vedra Beach, FLBuilt 1969 · S/N 32-1252 N4822ALybarger Michael L · Hot Springs, ARBuilt 1956 · S/N 22-3975 N4822GHighpoint Strategies LLC · Cypress, TXBuilt 1979 · S/N 17273370 N4822LMonaco Francis Achille · Martinez, GABuilt 1967 · S/N 28-4164 N4822SHolladay Pamela J · Louisville, KYBuilt 1969 · S/N 32-1253 N4823FEden'S Marine LLC · Jensen Beach, FLBuilt 1976 · S/N 28R-7635437 N4823PWilliams Charles S · Pearland, TXS/N 27-389 N4823TCrane Kenneth J · Clinton, INBuilt 1972 · S/N 32-7200025 N4823VStratus Air LLC · New Orleans, LAFirst renewal noticeBuilt 1980 · S/N 172RG0391 N4824GHickman Robert B · La Follette, TNBuilt 1979 · S/N 17273372 N4824SWilly Jack LLC · Wickenburg, AZBuilt 1970 · S/N 32-1255 N4824WFmp Properties LLC · Joplin, MOBuilt 1976 · S/N 14154 N4825ATodd Gary W · Rogers, OHBuilt 1956 · S/N 22-3978 N4825YHall William B · Vincentown, NJBuilt 1968 · S/N 25-4614 N4826SQuill Sean · Hadley, MABuilt 1969 · S/N 32-1257 N4826TSundance Air Services Inc · Alameda, CAS/N 28-7205202 N4826WRoss Steve M · Marion, ILBuilt 1976 · S/N 14156 N4827LDes Moines Flying Club · Indianola, IABuilt 1967 · S/N 28-4170 N4827SMckemy Michael L · Joppa, MDBuilt 1969 · S/N 32-1258 N4827YThief River Aviation Inc · Thief River Falls, MNBuilt 1968 · S/N 25-4618 N4828HWilson Aviation Club LLC · Wilmington, DEBuilt 2006 · S/N 11236 N4828LMcmordie Frank F IV · Dallas, TXBuilt 1967 · S/N 28-4171 N4828PFlying Nam LLC · Sheridan, WYBuilt 1981 · S/N 17274828 N4828SPuerto Rico Aircraft Leasing Corp · Ceiba, PRBuilt 1969 · S/N 32-1259 N4828TSun Star Holdings LLC · Binghamton, NYBuilt 1972 · S/N 28-7205203 N4829GSoaring Raven LLC · Seattle, WABuilt 1979 · S/N 17273377 N4829LHoughton Robert E · North Ferrisburgh, VTBuilt 1967 · S/N 28-4172

Back to AD 87-10-06 R1