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.

N2492YBenham Charles D · San Angelo, TXBuilt 1968 · S/N E-74 N2496TWillis Victor R · Eagle River, AKBuilt 1964 · S/N NAV-4-2496 N2497THoogasian Stephen M · Manassas, VABuilt 1973 · S/N NAV-4-2497 N2498SKatz Michael R Trustee · Merritt Island, FLBuilt 1976 · S/N 21061306 N249ASky West Aviation Inc Trustee · Albuquerque, NMBuilt 1977 · S/N CJ132 N249BB42m Aviation LLC · Shady Shores, TXBuilt 1979 · S/N D-10318 N249CGJulam Holdings LLC · Winter Park, FLBuilt 2018 · S/N E-4119 N249CKCarolina Landing LLC · Cambridge, MDBuilt 2003 · S/N 0766 N249CRA&W Air LLC · Aiken, SCBuilt 1979 · S/N TJ-249 N249DKK-Air Inc · Egg Harbor, WIBuilt 2017 · S/N TH-2487 N249MVAmble Tod M · Bozeman, MTBuilt 1979 · S/N CE-884 N249SAGribble Ted A · Paris, TXBuilt 2001 · S/N 29-0267 N249SPSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1975 · S/N 21060990 N249TJF Korbel & Bros · Guerneville, CABuilt 1966 · S/N TE-249 N249WHWhiskey Hotel LLC · O Fallon, MOBuilt 1978 · S/N CJ-147 N249WLSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N CJ-134 N249WSSmith Charles L III · Petaluma, CABuilt 2004 · S/N 0975 N249YJohnson Steven A · New Braunfels, TXBuilt 1969 · S/N CE-282 N24AGAegis Air LLC · Columbia City, INBuilt 1979 · S/N D-10293 N24BEMystic Knights Of The Air Lodge Inc · Canton, MSBuilt 1979 · S/N E-1540 N24BFWright Aviation Inc · Pikeville, KYBuilt 1980 · S/N E1736 N24BKN24bk LLC · Jupiter, FLBuilt 1977 · S/N E-1145 N24CFAmerica Aviation LLC · Yuma, AZBuilt 1979 · S/N 340A0659 N24CHDagostini Robert A · Mount Aukum, CABuilt 1975 · S/N 21060793 N24CJAtluas LLC · Anna, TXS/N 18502199 N24CRTop Flying LLC · Dover, DEBuilt 2008 · S/N 2923 N24CSMcmanigle Jeffrey · Osakis, MNBuilt 1975 · S/N 76-30804 N24EKMurphree Bridge Corp · Troy, ALBuilt 2008 · S/N TH-2248 N24FGCalifornia Department Of Fish And Game · Sacramento, CABuilt 1981 · S/N 18504207 N24HLLederer Henry A IV · Riderwood, MDBuilt 1976 · S/N CE-660 N24HSSandoval Ernest D · Cave Creek, AZBuilt 1978 · S/N 21062755 N24JVVan Blarcom John C II · Highland, CABuilt 1972 · S/N D-9337 N24KHMoffett Jules M DBA · Elmore, ALBuilt 1974 · S/N TE-996 N24LSickels Henry C · El Cajon, CABuilt 1964 · S/N D-7503 N24LKPrime Rib Aviation LLC · Nowata, OKBuilt 1980 · S/N E-1744 N24NHBeyer Roger · Paw Paw, MIBuilt 1981 · S/N 21064545 N24RAGrass Peter T · Hampstead, NCBuilt 1989 · S/N CE-1379 N24RCJeanes Guy R · Lampe, MOBuilt 1974 · S/N TE-994 N24RFAlatenn Construction & Properties LLC · Winchester, TNBuilt 2004 · S/N 1168 N24SCGriffin Samuel C · Doniphan, MOBuilt 1977 · S/N U20603868 N24SLSkye Tess Airlines LLC · Holmdel, NJBuilt 1980 · S/N 414A0610 N24WKCannizzaro Charles DBA · North Syracuse, NYBuilt 1967 · S/N D-8431 N24WWPark Avenue Group Inc · Stuart, FLBuilt 1975 · S/N 21060884 N2501SGonzales Gerald · Dallas, TXS/N 21061307 N2502QMaxim Aviation LLC · Sugarloaf Key, FLBuilt 2005 · S/N 42076 N2502TLert Peter S · Graton, CABuilt 1967 · S/N NAV-4-2502 N2503TLarue Mark C · Leander, TXBuilt 1967 · S/N NAV-4-2503 N2503XDm Aviation LLC · Lexington, SCBuilt 2018 · S/N TH-2503 N2504XInspire Technologies Inc · Caldwell, IDBuilt 1964 · S/N P206-0004 N2505XGaviaire Aviation LLC · El Reno, OKBuilt 1965 · S/N P206-0005

Back to AD 86-13-04 R3