Registered aircraft · 268

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:87-21-07-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:87-21-07-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:87-21-07-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:87-21-07-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:87-21-07-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:87-21-07-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.

N57084Sunflower Aviation LLC · Wilmington, DEBuilt 1974 · S/N 3184 N571DCMay Phillip Edward · Florence, ALBuilt 1971 · S/N 3099 N57262Steelesky Ltd · Maineville, OHBuilt 1975 · S/N 3239 N57266Department Of Public Safety · Baton Rouge, LABuilt 1974 · S/N 3208 N572TNShelton Paul K · Flushing, NYS/N 1360-38 N578WYBridger Aviation Services LLC · Belgrade, MTBuilt 1975 · S/N 3261 N58GSzarek Evelyn Personal Representative · Fairbanks, AKBuilt 1957 · S/N 680-519-189 N590DRRichardson Dean A · St Thomas, VIBuilt 1968 · S/N 1817-23 N590WAba Contractors Inc · Arcadia, OKBuilt 1954 · S/N 520-126 N6106XAir Margarita Inc · San Juan, PRBuilt 1960 · S/N 500B-941-28 N610BWCentral Airlines Inc · Leawood, KSBuilt 1965 · S/N 1523-185 N6114XHardy Gareth R · Thatcher, AZBuilt 1960 · S/N 500B-924-9 N611DWNav Solutions LLC · Lewes, DEBuilt 1961 · S/N 500B-1099-60 N6127XSalinas Manuel · Lamesa, TXBuilt 1960 · S/N 500A-970-32 N6136XGo Leasing Company · Phillipsburg, KSBuilt 1960 · S/N 500A-926-25 N6157XBluesky Geospatial Ltd · North Adams, MABuilt 1960 · S/N 500A-1009-37 N6164XRandall Kyle T · Klamath Falls, ORS/N 500B-1012-33 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 N6517VDesert Flyers LLC · Calexico, CABuilt 1973 · S/N 12037 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

Back to AD 87-21-07 R1