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.

N53236Principles Of Flight Training LLC · Lees Summit, MOBuilt 1981 · S/N 17274709 N5323EMaierhoffer Henry F · Sylvania, GAS/N 17271837 N5323FSilmi Amjad · Oakland, CABuilt 1976 · S/N 28-7790087 N5323HCook James N · Mission Viejo, CABuilt 1975 · S/N 17265403 N5323SGrig Aero LLC · Tulsa, OKBuilt 1980 · S/N R18201546 N5323WBibb Benjamin W · Efland, NCS/N 28-380 N5323XGlobal Aviation Corp · Farmingdale, NYBuilt 2013 · S/N 2842392 N5324LJohnson Jack D · Fresno, CABuilt 1968 · S/N 28-4627 N5324PN5324p LLC · Naples, FLBuilt 2001 · S/N 2843452 N5324TBlake Rodney · Trophy Club, TXBuilt 1972 · S/N 28-7225400 N5324XEchelon Flight Support LLC · Decatur, TXBuilt 1983 · S/N 5011 N53250Smith Leon Reese · Soldotna, AKBuilt 1943 · S/N 240 N53262Fort Leavenworth Flying Activity · Fort Leavenworth, KSBuilt 1981 · S/N 17274713 N53265Jeppesen Employees Flying Association · Englewood, COBuilt 1981 · S/N 17274714 N53266Jazzair LLC · Erie, COBuilt 2001 · S/N 3257233 N5326KCornelius Aviation Inc · Mooresville, NCBuilt 1980 · S/N 17274066 N5326LMarshall Aero LLC · San Antonio, TXBuilt 1968 · S/N 28-4629 N5326RHigher Milam Aviation LLC · Columbia, MOBuilt 2001 · S/N 3246196 N5327CTolleson Charles B Jr · Carpentersville, ILFirst renewal noticeBuilt 1985 · S/N 5050 N5327LLeipzig Richard R · Franklin, TNBuilt 1968 · S/N 28-4631 N5327PPowell Larry C · Fresno, CABuilt 1958 · S/N 24-371 N5327UJa Williams Investments LLC · Austin, TXBuilt 2003 · S/N T18208188 N5327WNoyes Daniel W · Oak Point, TXBuilt 1962 · S/N 28-384 N5328KAvanna LLC · Shaw Island, WABuilt 1980 · S/N 17274067 N5328LUniversity Of Illinois · Savoy, ILBuilt 2001 · S/N 4496108 N5328SArreola Christopher · La Verne, CABuilt 1970 · S/N 28-26940 N53293Tito Hector · Fayetteville, GABuilt 1981 · S/N 17274716 N5329PSpectrum Communications Inc · Moses Lake, WABuilt 1958 · S/N 24-373 N5329SAlabama Forestry Commission · Montgomery, ALBuilt 2003 · S/N 18281198 N5329WShamasna Rami · Homer Glen, ILBuilt 1962 · S/N 28-386 N5329YFlying Fish Ranch 29y LLC · Leesburg, FLBuilt 1963 · S/N 27-2406 N532BDSam Aviation LLC · Long Beach, CABuilt 1986 · S/N F17202244 N532CACulebra Aviation & Services LLC · San Juan, PRBuilt 1989 · S/N 2841282 N532CMRed Land Holdings LLC · Fayetteville, GAS/N 28-4632 N532DBell Marvin III · Mansfield, TXBuilt 1968 · S/N 680143 N532DREllebracht Steve · Sedalia, MOBuilt 1998 · S/N 3257060 N532FLCleared Skies LLC · Heber, AZBuilt 1971 · S/N 28-7125361 N532JHBobiak James R · Deary, IDBuilt 2012 · S/N 532 N532MTalovich Michael E · Farmington, NMBuilt 2003 · S/N 80532 N532PPenco Aviation LLC · Anchorage, AKBuilt 2004 · S/N 10381 N532RRRegistered aircraftBuilt 1977 · S/N 28R-7737037 N532SJohnson Lucas G · Pleasant Lake, MIBuilt 1965 · S/N 27-2966 N532SA2flyshrike LLC · Miramar, FLBuilt 1969 · S/N 1868-44 N532TWRooplal Robby Ashram · Spring, TXBuilt 1983 · S/N 28-8416006 N5330AGila Aviation LLC · San Luis, AZBuilt 2003 · S/N T18208190 N5330GKaris Aviation LLC · Poplar Bluff, MOBuilt 2001 · S/N 3257232 N5330LDavenport Ross K · Raleigh, NCS/N 28-4634 N5330PNielson Rex W · Pendleton, ORBuilt 1958 · S/N 24-374 N53310Lucente Michael A · Fort Myers, FLBuilt 2003 · S/N 18281199 N5331DPurdue Aviation LLC · West Lafayette, INBuilt 1979 · S/N 17272522

Back to AD 87-10-06 R1