Registered aircraft · 1,266

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:88-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:88-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:88-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:88-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:88-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:88-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.

N74ABAerial Digital Images LLC · Huntington Beach, CABuilt 1959 · S/N 23-1656 N74BBHy Aviation LLC · San Juan, PRBuilt 1971 · S/N 27-4750 N74LRRemy Lange · East Greenville, PAS/N 27-7405363 N74PLAncient Pelican Aviation LLC · Vero Beach, FLS/N 27-7405272 N7576YJ & P Toys Inc · Fort Myers, FLBuilt 1968 · S/N 27-4076 N762SUAlmost There Air LLC · Daytona Beach, FLBuilt 1977 · S/N 27-7754003 N767RJS&S Aircraft Inc · Bennington, VTBuilt 1964 · S/N 27-2651 N767SCClegg Stephen A · Port Orange, FLBuilt 1977 · S/N 27-7754060 N76AWPacific Fleet Aviation LLC · Rochester, NYBuilt 1975 · S/N 27-7554100 N76FCBlackhawk Holding Corp · Wilmington, DEBuilt 1976 · S/N 27-7654082 N76HKDodson International Parks Inc · Rantoul, KSBuilt 1958 · S/N 23-1423 N76NATri Flying Tigers Inc · Wilmington, DEBuilt 1960 · S/N 23-1909 N76SRTangipahoa Mosquito Abatement District # 1 · Hammond, LABuilt 1972 · S/N 27-7304976 N770BKHorizon Dreams LLC · Homer, GABuilt 1969 · S/N 27-4296 N7711MStauffer Michael S · Wichita Falls, TXBuilt 1965 · S/N 27-2936 N7718AScud Air 18a LLC · Morgan, UTBuilt 1975 · S/N 27-7554040 N773PTRegent Trust Co Trustee · Wichita, KSBuilt 1973 · S/N 27-7305144 N775TSSmith Paul A · Trufant, MIBuilt 1976 · S/N 27-7654069 N776MCCrew Sourcing Inc · Wilmington, DEBuilt 1957 · S/N 23-1078 N779MRRock N Robins Flying Service LLC · Palm City, FLBuilt 1976 · S/N 27-7654047 N77KKMensch Aviation LLC · Hastings, MIBuilt 1980 · S/N 278154002 N77KTRochna Stephen J · Fallon, NVBuilt 1958 · S/N 23-1306 N77YACrew Sourcing Inc · Wilmington, DEBuilt 1954 · S/N 23-61 N7812MAerial Farmer LLC · Missoula, MTS/N 27-3508 N78329Tindall William M · Pensacola, FLS/N 27-2329 N7842BLowe David M · Sacramento, KYBuilt 1956 · S/N 23-632 N78GSAir Mods And Repair Corp · Robbinsville, NJBuilt 1972 · S/N 27-4833 N78JT71793 LLC · San Luis Obispo, CABuilt 1978 · S/N 27-7854138 N78LJValiair Lc · Casper, WYBuilt 1973 · S/N 27-7304943 N790BBBeitel Robert R · Lake Wylie, SCBuilt 1968 · S/N 27-4023 N796AATechnical Education Services Inc · Virginia Beach, VABuilt 1977 · S/N 27-7854036 N797VCSantana Carlos A · San Juan, PRBuilt 1966 · S/N 27-3439 N79HLIndiana Paging Network Inc · Laporte, INS/N 27-7954046 N79MFSkyking Aviation Services LLC · Carson City, NVBuilt 1979 · S/N 27-7954098 N7AZDevaney Aviation Inc · Palm City, FLBuilt 1968 · S/N 27-3964 N7CBExperimental Aircraft Association · Oshkosh, WIBuilt 1972 · S/N 27-4802 N7HWAltieri Frank J · Somerton, AZBuilt 1967 · S/N 27-3718 N8006JCrimson Star LLC · Virginia Beach, VABuilt 1981 · S/N 27-8154009 N8050YGmm Records · Big Pine Key, FLBuilt 1962 · S/N 27-2098 N806RRIsland Flights Inc · Wilmington, DES/N 27-8054052 N8075RTahoe Creations Inc · Zephyr Cove, NVS/N 278054004 N80FFP A M Aviation LLC · Portsmouth, NHBuilt 1972 · S/N 27-7304958 N8124YMatthews Grover C · Hardinsburg, KYBuilt 1966 · S/N 27-3237 N81615Heyl Holdings LLC · Orlando, FLBuilt 1953 · S/N 27-2322 N817JBBenham James M · College Station, TXS/N 27-4561 N818CCFlyit LLC · Camas, WAS/N 27-2977 N818MJPika Design Inc · Spring Hill, KSS/N 27-2486 N821GMHoosier Aviation LLC · Terre Haute, INBuilt 1957 · S/N 23-1247 N8247GCity Of Stuttgart · Stuttgart, ARBuilt 1973 · S/N 27-7305012 N827ECPacific Fleet Aviation LLC · Rochester, NYBuilt 1980 · S/N 27-8154005

Back to AD 88-21-07 R1