Registered aircraft · 275

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:75-27-09-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-27-09-R2') 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:75-27-09-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-27-09-R2')
  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:75-27-09-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-27-09-R2')
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.

N5609DReed Steven W · San Marcos, TXBuilt 1957 · S/N BA-315 N5644DPlane Crazy Aviation LLC · Hickory, NCBuilt 1958 · S/N BA-360 N5668DLetzelter C J · Littleton, COBuilt 1959 · S/N BA-416 N5804CGeorge Andrew N · Corvallis, ORBuilt 1951 · S/N A579 N5867Yarbrough Michele E · Vacaville, CABuilt 1957 · S/N BA-333 N5959FMid Atlantic Air Museum · Reading, PABuilt 1965 · S/N BA-721 N59EJones Daniel S · Panama City Beach, FLBuilt 1956 · S/N BA-206 N5BACarlsbad Raceway Corp · Hemet, CABuilt 1962 · S/N BA-614 N5QQBowe Walter C Trustee · Sonoma, CABuilt 1946 · S/N A-223 N6000MValiair Limited Co Trustee · Casper, WYBuilt 1965 · S/N BA-727 N6047VWiplinger Robert D · Inver Grove Hgts, MNBuilt 1944 · S/N 8151 N60493Cam Air · Caldwell, IDS/N 52-10960 N606JWHeartland Aviation Inc · Alliance, NES/N AF-895 N606PARegistration Pending · Kingsford, MIRegistration pendingBuilt 1952 · S/N 52-10897 N6100CErickson Kirk E · Warroad, MNS/N 51-11532 N611WPScilleppi Gregory · Bainbridge Island, WABuilt 1952 · S/N AF-875 N6134Brown Garry M · Riverside, CABuilt 1952 · S/N CA-274 N62936Prop And Jet Air Museum · Romoland, CAS/N CA38 N62CJMcclain Dean L · Torrington, WYBuilt 1962 · S/N BA-633 N64463Air Combat Museum · Springfield, ILBuilt 1943 · S/N 4534 N6495DPreserve Aviation History LLC · Cape Coral, FLBuilt 1960 · S/N AF-449 N649BSpirit Engineering Inc · Grand Junction, COBuilt 1948 · S/N A-454 N651BSjc IV LLC · Lawrence, KSBuilt 1949 · S/N A-478 N6623Szostak Edward M · San Diego, CABuilt 1946 · S/N A-295 N663TBMcmillan Peter H · San Francisco, CABuilt 1964 · S/N BA-663 N6670Beinhauer Richard G · Naperville, ILBuilt 1952 · S/N CA-98 N6675Tarrington Thomas A · Mt Clemens, MIRegistration revokedBuilt 1952 · S/N CA-256 N67929Ladd Daniel T · Loudon, NHBuilt 1945 · S/N 6430 N69044Cross Brian K · Winters, CABuilt 1943 · S/N 4781 N6BAMcmanigle Jeff · Osakis, MNBuilt 1946 · S/N A-406 N700TNInternational Air Services Inc Trustee · Carson City, NVBuilt 1964 · S/N BA-718 N7032Gohman Charles S · Salinas, CABuilt 1943 · S/N 67232 N70GAAmerican Airpower Heritage Flying Museum Inc · Dallas, TXBuilt 1966 · S/N A-177 N70WWIsland City Seaplanes Inc · Cordova, AKS/N A-38 N712JSBeechcraft Heritage Museum · Tullahoma, TNBuilt 1959 · S/N BA-453 N7185Continental Title Trust LLC · Wichita, KSS/N CA-104 N71GJSkydive Greene County Inc · Xenia, OHBuilt 1954 · S/N AF-629 N727AVSkyline Eighteen LLC · Setauket, NYBuilt 1960 · S/N BA-560 N729MWpp Nautical LLC · Waller, TXBuilt 1960 · S/N BA-517 N73548Smith Salvage And Restoration Services LLC · New Berlin, TXS/N A-548 N737SWAztec Worldwide Airlines Inc · Wilmington, DEBuilt 1959 · S/N BA-402 N74GJSkydive Greene County · Xenia, OHBuilt 1961 · S/N BA-559 N75BBWarbirds 1 LLC · Chattanooga, TNBuilt 1952 · S/N 51-11638 N75GJSkydive Greene Co Inc · Xenia, OHBuilt 1964 · S/N BA-711 N75JCWilliams Austin · Valdosta, GABuilt 1946 · S/N A-256 N75QVr Jet LLC · Goshen, INBuilt 1951 · S/N AF-423 N7694CMiddle Keys Experimental Aircraft Association Inc · Marathon Shores, FLBuilt 1951 · S/N AF-24 N76ADynamic Avlease Inc · Bridgewater, VABuilt 1957 · S/N BA-262 N777XJFields David B · Midland, TXS/N BA-726 N7805CAtropos Group Inc · Arlington, VABuilt 1954 · S/N AF-640

Back to AD 75-27-09 R2