Registered aircraft · 20,483

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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.

N3688CDiedrich Steve A · Sandpoint, IDBuilt 1954 · S/N 31187 N3688UTaylor Aviation Inc · Fort Benton, MTBuilt 1963 · S/N 18255088 N3688YHarris Beth · Albuquerque, NMS/N 21058188 N3689CR D Management LLC · Central City, NEBuilt 1978 · S/N R18200309 N368CPWilliams Truman V · Robbinsville, NCBuilt 1980 · S/N R18201580 N368MState Of Montana · Helena, MTBuilt 1999 · S/N 18280598 N368MEWbl Air LLC · Minneapolis, MNBuilt 2000 · S/N 18280859 N3691YHunt Lynn C Trustee · Windsor, CAS/N 21058191 N3692CDevil Dusters Inc · Artesia, NMS/N 31191 N3692UPineview Ac Sales LLC · Bedford, WYBuilt 1963 · S/N 18255092 N3694UPara Tactics LLC · Shelton, WAFirst renewal noticeBuilt 1963 · S/N 18255094 N3694YScott Dale D · Alliance, OHBuilt 1963 · S/N 21058194 N3695COrton Dennis · Mead, COBuilt 1978 · S/N R18200312 N3695YAffordable Aviation Corp · Moriches, NYBuilt 1963 · S/N 21058195 N3696CTb Services LLC · Huntsville, ALBuilt 1978 · S/N R18200313 N3698CTomlinson John J · Kent, WABuilt 1954 · S/N 31197 N3698UJk Fly LLC · Abie, NEBuilt 1963 · S/N 18255098 N3699YAmfreight Logistics LLC · Deltona, FLBuilt 1963 · S/N 21058199 N369ANJet Aircraft Inc Trustee · Wilmington, DEBuilt 2000 · S/N 18280696 N369CBHahn Mitchell S · Chagrin Falls, OHS/N 182-66699 N369CMOharra Robert J · Buckley, WABuilt 1969 · S/N 18052058 N369GTTokar Gary J · Howell, MIBuilt 1960 · S/N 52608 N369HCCornerstone Mapping Inc · Roca, NEBuilt 1980 · S/N 21064049 N369JJB&B Aviation LLC · Evansville, INBuilt 1950 · S/N 7510 N369KSkydive Inc · Eagle Creek, ORBuilt 1963 · S/N 18254634 N369MBBarnes Matthew L · Pacific Palisades, CABuilt 1979 · S/N 18266986 N369METvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 20608125 N369WPLego Aviation LLC · Grimes, IABuilt 2025 · S/N 18283327 N36AFLewis Richard M Jr · Deltaville, VABuilt 1977 · S/N R18200104 N36APAnalysis Inc · Grand Junction, COBuilt 1971 · S/N 18052206 N36GBSmokey Bay Air Inc · Homer, AKBuilt 1972 · S/N U20601854 N36MSFlying Medical Service Inc · Grosse Pointe, MIBuilt 1976 · S/N U20603244 N36NHAlgar Linda · Tucson, AZBuilt 1980 · S/N 18267589 N36RCAiken Air Sales And Rentals LLC · Aiken, SCBuilt 1970 · S/N 18260311 N36SBWollenberg Jeffrey · Concrete, WABuilt 1956 · S/N 32271 N36STGriffith Joshua S · Breckenridge, TXBuilt 1979 · S/N 18267282 N36XArchangel Aviation LLC · Cleburne, TXBuilt 1976 · S/N 21061650 N36XBSchmidt Thomas P · Nunica, MIBuilt 1956 · S/N 33049 N36XCHangar C-403 LLC · Walnut Creek, CABuilt 1979 · S/N 18267223 N3700URydberg Lawrence · Albuquerque, NMBuilt 1963 · S/N 18255100 N3701UBowley Steven Jon · Phoenix, AZS/N 18255101 N3702UCc Flyers LLC · Corpus Christi, TXS/N 18255102 N3703YWilemon Ronald J · Tulsa, OKBuilt 1963 · S/N 21058203 N3705YMunoz Concepcion · Tulsa, OKBuilt 1963 · S/N 21058205 N3706UBrownfield Ken F · Boonville, MOS/N 18255106 N3706YAlexander Steve Craig · Shreveport, LABuilt 1963 · S/N 21058206 N3707DWilliams Charles S · Pearland, TXS/N 34407 N3708UCollins George H · Murfreesboro, TNBuilt 1963 · S/N 18255108 N3709DAbidance Inc · Winthrop, WABuilt 1957 · S/N 34409 N3709UMoser Scott M · Pisgah Forest, NCS/N 18255109

Back to AD 84-10-01 R1