Registered aircraft · 68,369

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:90-04-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:90-04-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:90-04-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:90-04-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:90-04-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:90-04-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.

N256ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881611 N2570ASlaughter Don Wayne · Farmville, NCBuilt 1952 · S/N 20-937 N2570MBills Nathan · Overland Park, KSS/N 12-921 N2570PStaneli Lee A · Kiana, AKBuilt 1956 · S/N 18-4310 N2570UJla Aero LLC · State College, PABuilt 1979 · S/N 28-8016036 N2571APeterson Ronald A · Campbell, TXBuilt 1952 · S/N 20-939 N2571EStrojny Andrew P Jr · Strongsville, OHBuilt 1978 · S/N 38-78A0578 N2571HRiker Walter T · Anchorage, AKBuilt 1979 · S/N 18-7909200 N2571MBoston Breeze Aviation LLC · Woburn, MABuilt 1977 · S/N 28-7890258 N2571PStrick Steffen G · Mc Grath, AKBuilt 1955 · S/N 18-4311 N2571QLubbe Klaus · Bethlehem, NHS/N 28-7790408 N2571XRegistration Pending · Augusta, KSRegistration pendingS/N 28-8516037 N2572ASteinhoff Aaron M · Ethel, WABuilt 1952 · S/N 20-938 N2572LBuick Robin B · Redding, CABuilt 1973 · S/N A1500485 N2572MChieftain LLC · Hot Springs, ARS/N 12-941 N2572PRegistration Pending · Roanoke, TXRegistration pendingS/N 18-4312 N2572UVan Scoy Bridget Anne · Shavertown, PAS/N 28-8016038 N2572VJarvis Michael Lynn · Orem, UTBuilt 1974 · S/N 177RG0620 N2572WFlournoy Thomas H · Port Republic, NJBuilt 1965 · S/N 3273 N2572ZRunia Jerry L · Estelline, SDBuilt 1977 · S/N 1000-77 N2573JBusch Bruce K Trustee · Cerritos, CABuilt 1979 · S/N 18-7909132 N2573VOldfield Raymond M Jr · Waupaca, WIBuilt 1974 · S/N 177RG0621 N2573WTrail Air LLC · Springdale, ARBuilt 1965 · S/N 3274 N25743Maile Frank W · Hamilton, NJBuilt 1981 · S/N 38-81A0072 N25746Collins Ronald Rs · Rutledge, TNBuilt 1981 · S/N 38-81A0069 N2574AJones Daryl L · Spokane, WABuilt 1952 · S/N 22-866 N2574GScholl John D · Alexandria, MNBuilt 1967 · S/N 55 N2574XBuckman Warren E III · Pennsburg, PABuilt 1985 · S/N 28-8516047 N2574ZKeegan Ace LLC · Tampa, FLS/N 354-77 N25754Jet & Rotor Aviation LLC · Sacramento, CABuilt 1977 · S/N 15280767 N25759Rogers Samuel I · Le Roy, KSBuilt 1981 · S/N 38-81A0071 N2575UCavu Aircraft LLC · Salisbury, NCBuilt 1979 · S/N 28-8016042 N2575VStone Tommy R · Jacksonville Beach, FLBuilt 1974 · S/N 177RG0622 N2575ZDavis Mary G · Friendswood, TXBuilt 1977 · S/N 1221-77 N2576AChristopher Steven · Claremore, OKBuilt 1952 · S/N 22-868 N2576FStefany Brian · Euless, TXBuilt 1966 · S/N 420 N2576PWiltz Brothers Inc · Krotz Springs, LAFirst renewal noticeBuilt 1955 · S/N 18-4316 N2576WKepler Anthony · Newberg, ORS/N 935 N25772Arnold Jonathan L · Warrensburg, MOBuilt 1977 · S/N 15280774 N25773Solberg Avn Co Inc · Whitehouse Station, NJBuilt 1977 · S/N 15280775 N25775Van Es Mark E · Laredo, TXBuilt 1977 · S/N 15280777 N25779Eads James · Saginaw, TXBuilt 1977 · S/N 15280780 N2577AHelms Michael R Sr · York, SCBuilt 1952 · S/N 22-869 N2577MBales Colton E · Wasilla, AKBuilt 1946 · S/N 12-1051 N2577WSiegel Theodore Matthew · Merritt Island, FLBuilt 1965 · S/N 3275 N25785Iggy Enterprises LLC · Gig Harbor, WABuilt 1977 · S/N 15280783 N2578WCain Mitchell J · Ellisville, MOBuilt 1965 · S/N 3276 N2578ZMcclaskey Leslie Paul · New Albany, OHBuilt 1977 · S/N 348-77 N2579ASharpe Matthew · Olympia, WABuilt 1951 · S/N 22-870 N2579DAnywhere Atp LLC · Mt Juliet, TNBuilt 1978 · S/N 38-79A0361

Back to AD 90-04-06 R1