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.

N464MMeyer Brent · San Antonio, TXBuilt 2002 · S/N 0221 N464PGoodgame Richard C · Fort Myers, FLBuilt 1966 · S/N D-8372 N464PCJordan Thomas Harvey III · Jasper, GABuilt 2004 · S/N 1208 N4651BGlenbear LLC · Kalispell, MTBuilt 1970 · S/N D-9157 N4651SScranton Christian · Walnut Creek, CABuilt 1975 · S/N E-766 N4651TUnited Indian Missions Inc DBA · Tucson, AZBuilt 1979 · S/N U20605255 N4653Q53 Quebec LLC · El Dorado, CABuilt 1972 · S/N 21059553 N4654MJetway LLC · Dover, DEBuilt 2005 · S/N 29-0370 N4654QStapleton Mark Christopher · Vestavia Hills, ALBuilt 1972 · S/N 21059554 N4656FCrowley Thomas Bannon III · Tigard, ORBuilt 1966 · S/N P206-0256 N4656KValley Agriculture LLC · Galt, CABuilt 1979 · S/N P21000251 N4657ATessos Air Service Inc · Wilmington, DES/N TH-41 N4657FDoxsee Arthur B · Bennington, VTS/N P206-0257 N4658FSedrel Steven M · Sparks, NVBuilt 1966 · S/N P206-0258 N465DLKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1979 · S/N 310R1622 N465PEHoyle Jason R · Grove, OKBuilt 1966 · S/N TE-112 N465SAGilmore Air LLC · Boca Raton, FLBuilt 2002 · S/N E-3465 N4660JStuder Al C · Shelby, MIBuilt 1980 · S/N T18803759T N4661CZiesmer Richard A · University Place, WABuilt 1974 · S/N 18502589 N4661MF & W Aviation Co LLC · Wilmington, DEBuilt 1978 · S/N E-1249 N4661ZRustair Inc · Anchorage, AKBuilt 1980 · S/N U20605998 N4663CKnox William D · Denver, COBuilt 1974 · S/N 18502590 N4665CKrissman Ryan · Gallup, NMBuilt 1977 · S/N U20603841 N4666NM & P Genpar LLC · Corpus Christi, TXBuilt 1978 · S/N 414A0059 N4668MBeechcraft Heritage Museum · Tullahoma, TNBuilt 1978 · S/N E-1252 N4668NSre Holdings LLC · Dewitt, MIFirst renewal noticeBuilt 1978 · S/N 414A0061 N466CAHyannis Air Service Inc DBA · Hyannis, MABuilt 1980 · S/N 402C0428 N466CDAsa Obion LLC · Union City, TNBuilt 2005 · S/N 1466 N466CESilver Fern Aviation Consulting LLC · Port Orange, FLBuilt 2004 · S/N 0999 N466LSBluefish LLC · Block Island, RIBuilt 1976 · S/N D-9952 N466MPMolar Air LLC · Martinez, GABuilt 2004 · S/N 0852 N466PJv Aviation LLC · Johnston, RIBuilt 1977 · S/N 310R0988 N466RCFlight Specific LLC · Helena, MTBuilt 1974 · S/N TE-995 N4671KNifong Robert B · Jacksonville, FLS/N P21000255 N4672FWilmeth Roy · Frankston, TXBuilt 1966 · S/N P206-0272 N4672KMartin Richard E Trustee · Colorado Springs, COBuilt 1979 · S/N P21000256 N4673FCody Richard A · Mclean, VABuilt 1966 · S/N P206-0273 N4673SGear Up Aviation LLC · Yukon, OKBuilt 1975 · S/N E-768 N4674NBorderline Sky LLC · El Paso, TXBuilt 1980 · S/N 340A1023 N4674UKlein David · Sebastopol, CABuilt 1983 · S/N 21064802 N4675CLane Robert W · Palmer, AKBuilt 1974 · S/N 18502592 N4677NLps Equipment And Acquisition Co Inc · Clarksburg, TNBuilt 1978 · S/N 414A0068 N4677QDahl Larry A · Cogswell, NDBuilt 1972 · S/N 21059577 N4678AIflyjctc82 LLC · Macomb, ILBuilt 1970 · S/N E-229 N4678FMullett Sean · Cleveland, TNBuilt 1966 · S/N P206-0278 N4678QPrairie Dog Aviation LLC · Sioux Falls, SDBuilt 1972 · S/N 21059578 N4679YExtreme Air LLC · Cottage Grove, WIBuilt 1980 · S/N 21063983 N467CDStarship 1 LLC · Houston, TXBuilt 2005 · S/N 1439 N467DBParamont Services Inc · Newbury Park, CABuilt 1978 · S/N 340A0467 N467DMMustang Sally Aviation LLC · Camden, SCBuilt 1973 · S/N 421B0377

Back to AD 86-13-04 R3