Registered aircraft · 54,015

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-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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.

N79584Ocean Breeze Aviation Inc · Wilton Manors, FLBuilt 1969 · S/N 17258195 N79585Valley Forge Aviators LLC · King Of Prussia, PABuilt 1973 · S/N 18261836 N79586Booth James L · Fort Collins, COBuilt 1973 · S/N 18261837 N79587Twj Aviation 2 LLC · Jacksonville, FLBuilt 1969 · S/N 17258198 N79589Aqua Irrigation Technologies LLC · Parma, IDBuilt 1973 · S/N 18261838 N7958BThrustline Aviation LLC · Happy Valley, ORS/N 29758 N7958VColbern Matthew · Anchorage, AKBuilt 1967 · S/N 18051858 N79590Corrigan Michael D · Hondo, TXBuilt 1973 · S/N 18261839 N79598Keck Shawn M · Santa Cruz, CAS/N 18261840 N79599Hull Aviation Inc · Decatur, ALBuilt 1969 · S/N 17258206 N7959BLaminack Dale Wayne · Ralls, TXS/N 29759 N7959TArrow LLC · Pateros, WABuilt 1960 · S/N 56659 N7959UShugart Tiffany C · Canfield, OHBuilt 1964 · S/N 17251959 N7960BHolte Martin W · Burnsville, MNS/N 29760 N7960THayden James R · West Fargo, NDBuilt 1960 · S/N 56660 N7961BGmitter Joseph J · Forest Lake, MNBuilt 1957 · S/N 29761 N7961GAlternate Air Inc · Seattle, WABuilt 1971 · S/N 17259661 N7961TBoardman Thomas M · Greenwich, NYBuilt 1960 · S/N 56661 N7961XCarruth Sam · Ripon, CABuilt 1961 · S/N 17248461 N7961ZBoho LLC · Lewes, DEBuilt 1963 · S/N 15060061 N7962BHall Jason J · Moses Lake, WABuilt 1957 · S/N 29762 N7962FFlying Colors Airparts Inc · Leesburg, FLBuilt 1966 · S/N 15064062 N7962GR House Leasing LLC · Stormville, NYBuilt 1971 · S/N 17259662 N7963BPerkins C Trent Blaise · Wonder Lake, ILBuilt 1957 · S/N 29763 N7963GAvian Leasing LLC · Bremerton, WABuilt 1971 · S/N 17259663 N7963TSawyers Susan J · Tazewell, VABuilt 1960 · S/N 56663 N7963UKischnick Brett A · Lapeer, MIBuilt 1964 · S/N 17251963 N7963XHairetown LLC · Johnson City, TNBuilt 1961 · S/N 17248463 N7964VNorris John R · Anchorage, AKBuilt 1967 · S/N 18051864 N7964XEdwards Jerry T · Palo Pinto, TXBuilt 1961 · S/N 17248464 N7965ZElliott Frank F · Mojave, CABuilt 1963 · S/N 15060065 N7966BBrashar Kevin · Anchorage, AKS/N 29766 N7966UPatterson Robert E Trustee · Petaluma, CABuilt 1964 · S/N 17251966 N7967BScholz Alan A · Rosamond, CABuilt 1957 · S/N 29767 N7967GWings Over Texas Holdings LLC · Denton, TXBuilt 1971 · S/N 17259667 N7967TMachowicz Mark M · Eastpointe, MIBuilt 1960 · S/N 56667 N7967XSchneider David L · Saginaw, MIBuilt 1961 · S/N 17248467 N7967ZBreckenridge Steven C · Farmington, ILBuilt 1963 · S/N 15060067 N7968BWaltz Patrick T · Delanson, NYBuilt 1957 · S/N 29768 N7968FFlyin Cowboys · Manning, NDBuilt 1966 · S/N 15064068 N7968TSiegel Donald S · Northampton, MABuilt 1960 · S/N 56668 N7969BConnolly Patrick J · Skaneateles, NYBuilt 1957 · S/N 29769 N7969GHealsburg Aviation · Healdsburg, CAS/N 17259669 N7969JPegasus Air Ventures LLC · Macedon, NYBuilt 1976 · S/N 18264871 N7969XBurnham Bros · Winner, SDBuilt 1961 · S/N 17248469 N796BGFlorida Aviation Career Training Inc · Saint Augustine, FLS/N 15280215 N796EPPrince Ellis C · Frierson, LABuilt 1972 · S/N 17260896 N796WTTaildragger LLC · Blackfoot, IDBuilt 1955 · S/N 26813 N7970FConnor Christopher Donnie · Chicago, ILBuilt 1966 · S/N 15064070 N7970GAmerican Patrols Inc · Midland, TXBuilt 1971 · S/N 17259670

Back to AD 87-20-03 R2