Registered aircraft · 18,497

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:86-13-04-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3') 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:86-13-04-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
  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:86-13-04-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
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.

N46WBBullen Riley P · Kingman, AZBuilt 2000 · S/N 29-0226 N4700FAssociated Equip Representatives Inc · Yakima, WABuilt 1966 · S/N P206-0300 N4701AWtfa LLC · Decatur, ALBuilt 1978 · S/N 414A0085 N4701KMorgan Carl A · Mayhill, NMBuilt 1969 · S/N TE-717 N4701QWindsor Greg A · Anchorage, AKBuilt 1966 · S/N 185-1155 N4702MVolant Aviation LLC · Brenham, TXBuilt 1978 · S/N D-10127 N4702QDriggs Daniel H · Anchorage, AKBuilt 1966 · S/N 185-1156 N4702VBrown Anthony · Pacoima, CABuilt 1967 · S/N 30053 N4703VLangham William Hb · Uvalde, TXBuilt 1967 · S/N 30054 N4704ABrown Helicopter Inc · Pensacola, FLBuilt 1974 · S/N 18502426 N4706QRegistration Pending · Polson, MTRegistration pendingBuilt 1966 · S/N 185-1160 N4708QCole Brent R · Anchorage, AKBuilt 1966 · S/N 185-1162 N470AWWhitesell Paul Trustee · Plano, TXBuilt 1966 · S/N D-8073 N470BCCorvus Flight LLC · Salinas, CABuilt 1977 · S/N 414-0918 N470CDPrecision Machine Tool Solutions LLC · Sinking Spring, PABuilt 2005 · S/N 1611 N4710QNeitz Frank A · Bethel, AKBuilt 1966 · S/N 185-1164 N4711FCharter Equine Inc · Amarillo, TXBuilt 1966 · S/N P206-0311 N4712KMclellan Bruce A Trustee · Bend, ORBuilt 1979 · S/N P21000262 N4714CGorman Aviation LLC · Bartlesville, OKBuilt 1979 · S/N 21063596 N4714VSwanland Robert C · Grants Pass, ORBuilt 1967 · S/N 30069 N4715FRegistration Pending · Ukiah, CARegistration pendingBuilt 1966 · S/N P206-0315 N4715WKelley Christopher L · La Quinta, CABuilt 1980 · S/N P21000624 N4716VFields William F · Hazard, KYBuilt 1967 · S/N 30068 N4716XJessup Sheila · Dublin, CABuilt 1980 · S/N U20605527 N4717CCt Aviation LLC · Fort Worth, TXBuilt 1979 · S/N 21063598 N4718FPbar Inc · Joseph, ORBuilt 1966 · S/N P206-0318 N471HBMyers Ralph E · San Clemente, CABuilt 1977 · S/N 414-0923 N471MASwift Aviation LLC · Decatur, TNBuilt 1979 · S/N 414A0279 N4720CNesbit Gary M · West Linn, ORBuilt 1979 · S/N 21063601 N4720PKlingler Larry R · Wolfeboro, NHBuilt 1978 · S/N P21000090 N4720QFielding William J IV · Scarborough, MES/N 185-1174 N4720VBurr Philip A · Bethel, CTBuilt 1967 · S/N 30060 N4720YKraemair Aviation LLC · Sauk City, WIBuilt 1980 · S/N 21063992 N4721MRegistered aircraftBuilt 1978 · S/N CE-777 N4721QXtreme Attitudes LLC · Sanford, NCBuilt 1966 · S/N 185-1175 N4722FStoskopf Scott W · El Dorado, KSBuilt 1966 · S/N P206-0322 N4723FStraightin LLC · Paauilo, HIBuilt 1966 · S/N P206-0323 N4723YRegina Air Cargo Corp · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 1980 · S/N 21063993 N4724QDehart T James Trustee · Kalama, WABuilt 1978 · S/N 18503550 N4725FHigh Peak Air LLC · Vernal, UTBuilt 1966 · S/N P206-0325 N4726MNicholas James · Steens, MSBuilt 1978 · S/N CE-778 N4726QBecker Flying Service Inc · Hartington, NEBuilt 1976 · S/N 18802496T N4726UMonogram Aviation Services LLC · Coeur D Alene, IDS/N U20605070 N4726YMeisner David B · Meridian, IDBuilt 1980 · S/N 21063994 N4728MHitchins Michael B · Lake Havasu City, AZBuilt 1978 · S/N E-1256 N4729CSullivan David C · St George, UTBuilt 1979 · S/N 21063604 N4729WMichael J Kraynick Pllc · Hailey, IDBuilt 1965 · S/N 21058621 N472CDLorton Kenneth Patrick · Brooklyn, NYBuilt 2004 · S/N 1197 N472NMMission Aviation Fellowship · Nampa, IDS/N 20700786 N4730EState Of Alaska · Kodiak, AKBuilt 1979 · S/N 18503848

Back to AD 86-13-04 R3