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.

N4112RLangenegger Glenn · Burns, KSBuilt 1968 · S/N 32-40431 N4112WLian Ian · Beaumont, TXBuilt 1967 · S/N 32-40175 N41139Blair Mark Winston · Zachary, LAS/N R18200889 N4113BRishell Charles G · Columbia, MDBuilt 1974 · S/N 74-32-145 N4113EEllenburg Sixth Family Limited Partnership · Anchorage, AKBuilt 1978 · S/N 18-7809071 N4113HWettstein Tim · Manhattan Beach, CABuilt 1978 · S/N 24-0628 N4113JParnell Jerry L Jr · Panama City, FLBuilt 1966 · S/N 28-22429 N4113XDyer Dillon G · Clatskanie, ORBuilt 1968 · S/N 210 N4113YKlintrin Collectibles LLC · Downers Grove, ILBuilt 1976 · S/N 591-76 N4114Stauder Gregory P · Galena, ILBuilt 1968 · S/N 413 N41142Waters Agricultural Laboratories Inc · Camilla, GABuilt 1983 · S/N 31-8352034 N4114BGrove Mark T · Cave Creek, AZBuilt 1993 · S/N 14598 N4114JCrader Air LLC · Jackson, MOBuilt 1966 · S/N 28-22430 N4114KNorth Florida Soaring Society Inc · Jacksonville, FLBuilt 1966 · S/N 25-4043 N4114PChieftain 4114p LLC · Lewes, DEBuilt 1982 · S/N 31-8252069 N4114WWilliams Frank J · Mendon, MABuilt 1967 · S/N 32-40177 N4114XDaniel William G Jr · Penhook, VABuilt 1968 · S/N 211 N4114YLight & Variable LLC · Arlington, VABuilt 1976 · S/N 947-76 N41152Mb Stedman Airplane LLC · Marble Falls, TXBuilt 1993 · S/N 27-0155 N4115CHails Betsy B · Montgomery, ALBuilt 1978 · S/N R18200325 N4115EBcs Properties LLC · Mead, COBuilt 1978 · S/N 18-7809072 N4115HPeters Alan M · Arcola, TXBuilt 1947 · S/N 12-3548 N4115VLtf Air LLC · Nashua, NHBuilt 1983 · S/N 31-8312012 N4115XCenterline Aero LLC · Kalispell, MTBuilt 1968 · S/N 213 N4115YN4115y LLC · Munday, TXS/N 948-76 N4115ZCondict Wynn G · Saratoga, WYBuilt 1964 · S/N 18-8154 N41166Moyer Aviation Inc · Tobyhanna, PABuilt 1984 · S/N 31-8452008 N4116EBlr Aviation LLC · Eagle River, WIBuilt 1978 · S/N 18-7809073 N4116JKerns Brothers LLC · Boardman, ORS/N 28-22433 N4116KRed Cloud One LLC · Cornwall, NYBuilt 1984 · S/N 31-8312019 N4116ZEbinger Michael R · Mc Grath, AKBuilt 1964 · S/N 18-8155 N41177Chigusa Sean S · Rch Palos Vrd, CABuilt 1974 · S/N 28-7415129 N4117FMade U Look Promotions LLC · Glastonbury, CTBuilt 1976 · S/N 28-7790004 N4117JKeeven Thomas R · Elsberry, MOS/N 28-22434 N4117YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1976 · S/N 592-76 N4117ZC And R Hospitality LLC · Burkeville, TXBuilt 1984 · S/N 31-8452015 N41180Calladine Matthew · Wellsville, NYBuilt 1974 · S/N 28-7405081 N41189Yr-Aircraft Leasing LLC · Bethel, AKBuilt 1984 · S/N 31-8553002 N4118B4118b Leasing LLC · Hallandale Beach, FLBuilt 1984 · S/N 31-8452021 N4118GYr-Aircraft Leasing LLC · Bethel, AKBuilt 1984 · S/N 31-8453001 N4118HFugate Terry L · Atoka, OKS/N 2197 N4118JSale Reported · Dallas, TXSale reportedBuilt 1966 · S/N 28-22435 N4118RHampsch Jeremy · Hauser, IDBuilt 1968 · S/N 32-40437 N4118WWisniewski Travis J · Porter, TXBuilt 1967 · S/N 32-40181 N4118ZSupercub1 LLC · Anchorage, AKBuilt 1964 · S/N 18-8159 N41193Stephen Air LLC · Woodsfield, OHBuilt 1974 · S/N 28-7425203 N41194Fisher Samuel K · Narvon, PABuilt 1974 · S/N 28-7415132 N41195Flaus Deborah L · Washington, PABuilt 1974 · S/N 28-7415133 N41197Fancher Ronald Albert · Linden, TNBuilt 1974 · S/N 28-7405082 N4119EBigham David A · Phoenix, AZBuilt 1978 · S/N 18-7809077

Back to AD 87-10-06 R1