AD 87-10-06 R1

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

N738NQSimmons Calvin L · Washington, UTBuilt 1979 · S/N R18200945N738NSGibson Field · Paso Robles, CABuilt 1979 · S/N R18200947N738NTChamberlain Sheldon L · Patterson, LABuilt 1977 · S/N 17270114N738NUAeroflyin Corp · Miramar, FLS/N 17270115N738NXAbove All Aviation Inc · Goleta, CABuilt 1977 · S/N 17270118N738NYMonmouth Area Flying Club Inc · Lakewood, NJBuilt 1977 · S/N 17270119N738PDMontgomery Robert E · Fairfax, VABuilt 1977 · S/N 17270123N738PGBas Part Sales LLC · Greeley, COBuilt 1979 · S/N R18200949N738PHStroemsvik Kristian · Strasburg, VABuilt 1977 · S/N 17270127N738PJGeebee Ventures LLC · Belgrade, MTBuilt 1977 · S/N 17270128N738PKTss Flying Club Inc · Bethesda, MDBuilt 1979 · S/N R18200950N738PMDaviation Inc · Willoughby, OHBuilt 1977 · S/N 17270131N738PNPapa November LLC · Orlando, FLBuilt 1977 · S/N 17270132N738PP8 Papa Papa Flyers LLC · Little Rock, ARBuilt 1977 · S/N 17270133N738PRS D Sky Tales Inc · Chuckey, TNBuilt 1979 · S/N R18200951N738PTMitchell Clayton M · Monte Vista, COBuilt 1977 · S/N 17270137N738PVLawn Dart Flyers LLC · Shelburne, VTBuilt 1977 · S/N 17270139N738PWLamey Kevin P Trustee · Missoula, MTS/N R18200952N738PXMacomb County Sheriffs Aviation Division · Oakland, MIBuilt 1977 · S/N 17270141N738QASorbi Aviation Inc · El Cajon, CAFirst renewal noticeBuilt 1977 · S/N 17270144N738QBRed Baron LLC · Middletown, DEBuilt 1977 · S/N 17270145N738QCMagda Michael J · Whitmore Lake, MIBuilt 1977 · S/N 17270146N738QEAero Aviation Transportion Inc · Wilmington, DEBuilt 1977 · S/N 17270148N738QFClark Josh D · Morehead, KYS/N 17270149N738QJCarr Lonnie G · Sparta, TNBuilt 1977 · S/N 17270152N738QKSik Kelly · Murrieta, CABuilt 1979 · S/N R18200953N738QMWalters James F · Richton, MSBuilt 1977 · S/N 17270155N738QNLagos Aviation LLC · Houston, TXBuilt 1977 · S/N 17270156N738QPRegistration Pending · Langsville, OHRegistration pendingBuilt 1977 · S/N 17270157N738QUQ U Air LLC · Millersburg, INBuilt 1977 · S/N 17270162N738QVChristensen Gerald T Trustee · Elk Grove Village, ILBuilt 1979 · S/N R18200955N738RAMartin Brandon · Duncan, OKBuilt 1977 · S/N 17270168N738RCHeavin James W · Salem, MOBuilt 1977 · S/N 17270170N738RFSevere Clear Aviation LLC · Alpine, CABuilt 1977 · S/N 17270173N738RKPapa Sierra LLC · Wilmington, DEBuilt 2001 · S/N 80183N738RLFlying Dreams 2 LLC · Louisville, KYBuilt 1977 · S/N 17270177N738RNMccall Freddie W · Brewton, ALS/N 17270179N738RPDodd Charles E Jr · Quitman, GABuilt 1977 · S/N 17270180N738RSGentzler Charles R · Thousand Oaks, CABuilt 1979 · S/N R18200957N738RUCarter Steve E · Downers Grove, ILBuilt 1977 · S/N 17270185N738RXMccormick Eugene C · Tyler, ALBuilt 1977 · S/N 17270188N738SThree Eight Sierra Inc · Old Monroe, MOBuilt 2004 · S/N 135N738SEMorcom Aviation Services Inc · Everett, WABuilt 1977 · S/N 17270194N738SHRaider Aviation LLC · Lubbock, TXS/N 17270197N738SJBirmingham Flight Center LLC · Birmingham, ALS/N 17270198N738SPOur Jett LLC · Englewood, COBuilt 1977 · S/N 17270203N738SRRise Aviation LLC · Auburn, ALBuilt 1977 · S/N 17270205N738SSFalcon Aire LLC · Mequon, WIBuilt 1978 · S/N 17270206N738STBergstrom Aircraft Inc · Pasco, WABuilt 1977 · S/N 17270207N738SUNab Aviation Holdings LLC · Cocoa Beach, FLS/N 17270208
Back to AD 87-10-06 R1