Registered aircraft · 245

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-12-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-12-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-12-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-12-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-12-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-12-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.

N6212XCummins Donald · Natchitoches, LABuilt 1963 · S/N 500B-1102-63 N6215XWeber Donald E · Saint David, AZBuilt 1961 · S/N 500B-1056-45 N6217DSmithey Larry M · Wake Forest, NCS/N 680-485-155 N6222DRobertson C A · Phoenix, AZS/N 680-490-160 N6224XN6224x LLC · Lake Havasu City, AZBuilt 1961 · S/N 500B-1126-72 N6226DNielsen James R · Carson City, NVBuilt 1963 · S/N 1307-60 N623FSMorse Edward K Jr · Wasilla, AKS/N 578 N6253XMoudy James D · Fairhope, ALBuilt 1961 · S/N 680F-1089-67 N6258XJ & S Aviation LLC · Fairview, OKBuilt 1961 · S/N 500B-1155-84 N6266XWells & West Inc · Murphy, NCBuilt 1962 · S/N 500A-1141-61 N6267BRosario Angela · San Juan, PRBuilt 1958 · S/N 662 N6272XPrairie Aviation Museum Inc · Bloomington, ILS/N 680F-1159-83 N6277BCerra Eduardo · Miami, FLS/N 500-686-33 N6278DSale Reported · Oklahoma City, OKSale reportedBuilt 1957 · S/N 548216 N6287XWallen Joe · Knoxville, TNS/N 500A-1250-75 N6290BCaribbean Shuttle LLC · Aventura, FLBuilt 1958 · S/N 67929 N6290XDelcor Electronics Inc · Mount Vernon, NYBuilt 1962 · S/N 500B-1178-91 N6296XDye Michael M · Bastrop, TXBuilt 1962 · S/N 500A-1254-78 N62LLAirborne Research LLC · Fort Pierce, FLBuilt 1961 · S/N 500A-1122-58 N630KCCentral Airlines Inc · Leawood, KSBuilt 1960 · S/N 500B-997-28 N630TAN630ta Corp · Miami, FLBuilt 1962 · S/N 1214-112 N634CTCorsair Aviation LLC · Yuba City, CABuilt 1972 · S/N 3121 N6350UWeatherbird Ltd · New York, NYRegistration revokedBuilt 1965 · S/N 1431-150 N6369USpecialty Aero Services LLC · Bayside, WIBuilt 1964 · S/N 1465-165 N6619VTeton Leasing LLC · Pocatello, IDBuilt 1968 · S/N 1824-24 N666KABeulah Ranch LLC · Cheyenne, WYBuilt 1965 · S/N 1500-177 N669JCloud Splitter Inc · Columbia, CABuilt 1963 · S/N 500B-1304-119 N677JRRoach James M · West Bountiful, UTBuilt 1958 · S/N 680-647-254 N67SSCalongne Klint · Cypress, TXS/N 1727-30 N680FTTwin Aviation LLC · Natchitoches, LAS/N 680F-1120-73 N680PLDw Educational Research Inc · Fowler, CABuilt 1961 · S/N 680F-969-27 N680RRNizex Inc · Jackson, GABuilt 1963 · S/N 1361-139 N68113Gogoplex LLC · Wilmington, DEBuilt 1956 · S/N 680-316-11 N6819QWalker Gilbert R · Brentwood, TNBuilt 1957 · S/N 680-488-158 N6883SWebb Ronald G · Dickson, TNBuilt 1956 · S/N 680-407-83 N690RRCentral Airlines Inc · Leawood, KSBuilt 1962 · S/N 500B-1169-88 N698RTsi Disaster Recovery LLC · Melbourne, FLBuilt 1960 · S/N 500A-910-19 N69PTAerofix Structural Service LLC · Horn Lake, MSS/N 1397-143 N70DMartin Ernest · Sandpoint, IDS/N 268 N711NECommander Flight Group LLC · Charlotte, NCBuilt 1958 · S/N 667 N713SPCentral Airlines Inc · Leawood, KSBuilt 1964 · S/N 500B-1480-172 N715LGGuy Transportation Ltd · Carolina, PRS/N 500B-1174-90 N716TCCentral Airlines Inc · Leawood, KSBuilt 1962 · S/N 500B-1225-102 N730RFCommand Aero LLC · Chicago, ILS/N 895-4 N741CAHarold F Mowery · Mechanicsburg, PABuilt 1974 · S/N 3191 N747HSale Reported · Santa Rosa, CASale reportedBuilt 1965 · S/N 1492-72 N757DDBosco74 LLC · Wilmington, DEBuilt 1966 · S/N 1652-9 N75JRWillis James R · Belleview, FLBuilt 1965 · S/N 1484-174 N760VRSkyway II LLC · Naples, FLBuilt 1972 · S/N 3138 N777CMCentral Airlines Inc · Leawood, KSBuilt 1964 · S/N 1412-147

Back to AD 75-12-09 R2