Registered aircraft · 26,232

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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.

N7197TNelson Jim · Midlothian, TXS/N 46797 N7198FCessna Flyers LLC · Bountiful, UTBuilt 1966 · S/N 15063798 N7198XScott Allexus D · Melbourne, ARBuilt 1961 · S/N 15059298 N7199FSale Reported · Pikeville, TNSale reportedBuilt 1966 · S/N 15063799 N7199XGrand Aviation LLC · Celina, OHBuilt 1961 · S/N 15059299 N71CPKitty Hawk Flight Training And Tours LLC · Nags Head, NCBuilt 1972 · S/N 15073229 N71DYYoakley Donald William · Fleming Island, FLBuilt 2026 · S/N 001 N71MMMilke Shaun M · Anchorage, AKFirst renewal noticeBuilt 1978 · S/N 1978-001 N71TDDunn William F · Del Norte, COBuilt 1957 · S/N 29706 N71USoileau Mark C · Angleton, TXBuilt 1946 · S/N 11229 N71ZKKlinger Keith · Groveland, FLBuilt 1947 · S/N 13103 N72004Irvine Paul E · Antioch, CABuilt 1946 · S/N 3431 N72005Kerr Jerry T · Mount Vernon, WABuilt 1946 · S/N 3432 N7200AMcdaniel Neil R · Wray, COBuilt 1956 · S/N 29300 N7200TYavitch Barry E · Palmdale, CABuilt 1959 · S/N 46800 N7200XGloris Robert J · Lago Vista, TXBuilt 1961 · S/N 15059300 N7201ACarleson Jesse R · Wasilla, AKFirst renewal noticeBuilt 1956 · S/N 29301 N7201THorton Rusty Ray · Monroe, GABuilt 1959 · S/N 46801 N7202TArcangeli Harry L · Lakemont, NYBuilt 1959 · S/N 46802 N7202XFielding John N · Scarborough, MEBuilt 1961 · S/N 15059302 N72037Simmons Jason E · Austin, TXS/N 3464 N7203AJohnson Lawrence F · Anchorage, AKBuilt 1956 · S/N 29303 N7203TRegistration Pending · Amarillo, TXRegistration pending, pending cancellationBuilt 1959 · S/N 46803 N7204SAerolab LLC · Hartwell, GAS/N 15067904 N7204TGaponoff Mark A · Mercer Island, WAFirst renewal noticeBuilt 1960 · S/N 46804 N7205SRegistration Pending · Dillingham, AKRegistration pendingBuilt 1967 · S/N 15067905 N7206ABerle William M · White Hills, AZS/N 29306 N7206GKane Gabriel · Yucaipa, CABuilt 1973 · S/N 15074622 N7206TSimmons William E · Port Orchard, WABuilt 1959 · S/N 46806 N7206XChickasha Wings Inc · Chickasha, OKS/N 15059306 N72076Hughes Glenn D · Wrightsville Beach, NCBuilt 1946 · S/N 3503 N7207SRademacher Kenneth J · Cleveland, TXBuilt 1967 · S/N 15067907 N7207TMrzena Matthew D · Wasilla, AKBuilt 1959 · S/N 46807 N7207XAbetz Jacob R · Tacoma, WABuilt 1961 · S/N 15059307 N7208XReese Scott D · New London, MNBuilt 1961 · S/N 15059308 N7209MColman Aviation LLC · Pocatello, IDBuilt 1958 · S/N 55509 N7209TBouchez Lawrence T · Manhattan Beach, CABuilt 1959 · S/N 46809 N7209XSims Hollow M · Lithonia, GABuilt 1961 · S/N 15059309 N720CUBadinelli Ralph D · Blacksburg, VABuilt 1946 · S/N 9307 N720PCBaker Bernie Jr · Warrensburg, NYBuilt 1956 · S/N 18-5177 N72101Tango Thirty One Aero Clube Inc · Mckinney, TXBuilt 1946 · S/N 9266 N72105Williams Steve C · Elgin, SCS/N 9270 N72107Halsmer Elisabeth A · Dry Ridge, KYBuilt 1946 · S/N 9272 N7210MHensman Bruce E · Steamboat Springs, COBuilt 1958 · S/N 55510 N7210SAccelerated Aviation Instruction LLC · Owatonna, MNS/N 15067910 N7210XStacey William B · Lebanon, TNBuilt 1961 · S/N 15059310 N72114Foxlin Xyla Rei · Culver City, CABuilt 1946 · S/N 9279 N72115Church Phillip M · Statesville, NCBuilt 1946 · S/N 9280 N72116Liebeler Greta C · Mclean, VABuilt 1946 · S/N 9281 N7211ATravis Michael B · Camano Island, WABuilt 1956 · S/N 29311

Back to AD 94-05-05 R1