Registered aircraft · 7,563

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:2000-25-02-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:2000-25-02-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:2000-25-02-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:2000-25-02-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:2000-25-02-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:2000-25-02-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.

N36028Armstrong Robert Reno · Lakin, KSS/N 264-73 N36031Markey William C Trustee · Wenatchee, WABuilt 1973 · S/N 540-73 N36035Hilstad Steve D · Mayville, NDBuilt 1973 · S/N 100-73 N3604ECollier-Sanuki J Scott · Fairbanks, AKBuilt 1947 · S/N 11AC-1820 N3608EFranklin James T · Vero Beach, FLBuilt 1947 · S/N 7AC-6941 N3611EMcbride Scott P · Kenai, AKBuilt 1947 · S/N 7AC-6943 N36137Big Bend Community College · Moses Lake, WABuilt 1973 · S/N 542-73 N36138Smith Brian Lee · Solvang, CABuilt 1973 · S/N 382-73 N36139Flying Sportsmen Inc · Sussex, NJBuilt 1973 · S/N 105-73 N3613ESmith Nathan L · Citra, FLBuilt 1947 · S/N 7AC-6944 N36140Phillips James M · Wilmington, NCBuilt 1973 · S/N 957-73 N36141Averill Terry B · Litchfield, MEBuilt 1973 · S/N 544-73 N36173Schuster Darin D · New Castle, DEBuilt 1973 · S/N 546-73 N36174Meise Fred W · Moses Lake, WABuilt 1973 · S/N 958-73 N36176Otte Duane P · Plainfield, INBuilt 1973 · S/N 101-73 N36178California Flyers Training Solutions LLC · Sun City, CABuilt 1973 · S/N 383-73 N3618ETennis Gayland L · Bath, MIBuilt 1947 · S/N 7AC-6948 N361ACBond Robert E · Kingsville, MOBuilt 1974 · S/N 497-75 N36233Meyer Wayne G · Bozeman, MTS/N 548-73 N36242Landmark Search Group · Spokane, WAS/N 551-73 N36244Neel Aviation LLC · Lakeland, FLBuilt 1973 · S/N 103-73 N36245Ridge Logan D · Lake City, ARBuilt 1973 · S/N 587-73 N36246Sikes Ethan L · Collins, GAS/N 552-73 N36248Sipes Austin L Jr · North Pole, AKBuilt 1973 · S/N 573-73 N36249Davis Gary L · Sun City, AZS/N 554-73 N36250Floura David P · Blackduck, MNBuilt 1973 · S/N 385-73 N36251Gourley Eric G · Eastsound, WABuilt 1973 · S/N 274-73 N36266Barney Bill L · Fairbanks, AKBuilt 1973 · S/N 560-73 N36267Ashcraft Keirsten · Longview, TXS/N 269-73 N36285Schreiber Ray R · New Palestine, INBuilt 1973 · S/N 964-73 N36288Monke David W · Fontanelle, NEBuilt 1973 · S/N 563-73 N3630EAndrade Joseph Jr · Payson, AZBuilt 1947 · S/N 11AC-1830 N36335Simmons Darren · Diamondhead, MSBuilt 1973 · S/N 271-73 N36336Mierzejewski Karl · State College, PABuilt 1973 · S/N 965-73 N36337Boling Derek · Paragould, ARBuilt 1973 · S/N 107-73 N36349Richardson Thomas R · Valleyford, WABuilt 1973 · S/N 967-73 N36350Hennager Eric D · Langdon, NDBuilt 1973 · S/N 272-73 N36351Mueller Michael A · Seguin, TXBuilt 1973 · S/N 567-73 N36352Smith Steven Glen Trustee · Orem, UTBuilt 1973 · S/N 108-73 N36353Mcbride Mark · Sutton, MABuilt 1973 · S/N 968-73 N3635EJonas Nicole M · Oshkosh, WIBuilt 1947 · S/N 11AC-1831 N36382Pallaziol Delia N · Vista, CABuilt 1973 · S/N 389-73 N3639EKelso Samuel G Trustee · Louisville, TNBuilt 1947 · S/N 7AC-6961 N36411Runsick Michael C · Wynne, ARBuilt 1973 · S/N 273-73 N36412Martinsen John James · Aberdeen, WABuilt 1973 · S/N 970-73 N36413Steward James D · Monument, COBuilt 1973 · S/N 109-73 N36414Dewitt Elvin H · Santa Monica, CABuilt 1973 · S/N 390-73 N36417Huber Weylin L · Aberdeen, SDBuilt 1973 · S/N 575-73 N3641ERegistration Pending · Ottumwa, IARegistration pendingBuilt 1947 · S/N 11AC-1833 N3642EBrotheridge Bryan R · Merritt Island, FLBuilt 1947 · S/N 7AC-6963

Back to AD 2000-25-02 R1