Registered aircraft · 3,961

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

N467DBParamont Services Inc · Newbury Park, CABuilt 1978 · S/N 340A0467 N467DMMustang Sally Aviation LLC · Camden, SCBuilt 1973 · S/N 421B0377 N4680NRentz Communications Inc · New Smyrna Beach, FLBuilt 1978 · S/N 414A0070 N468KWLance Johnson Ministries Inc · Calhoun, GABuilt 1962 · S/N 310G0058 N4693NWade Air LLC · West Palm Beach, FLS/N 414A0079 N4698AExpress Air LLC · Wilmington, DES/N 414A0083 N469CJHerndon Aviation LLC · Kokomo, INBuilt 1980 · S/N 421C1018 N469LCGaletti Ralph R · Albuquerque, NMBuilt 1974 · S/N 421B0627 N469TMAerostream Services LLC · Cincinnati, OHS/N 310K-0202 N46CGGlobal Building Investments Inc · Scottsdale, AZS/N 310P0146 N46RKAir Positive LLC · Selbyville, DEBuilt 1969 · S/N 310P0122 N4701AWtfa LLC · Decatur, ALBuilt 1978 · S/N 414A0085 N470BCCorvus Flight LLC · Salinas, CABuilt 1977 · S/N 414-0918 N471BWPatriot Environmental LLC · Meeker, OKS/N 421C0640 N471HBMyers Ralph E · San Clemente, CABuilt 1977 · S/N 414-0923 N471MASwift Aviation LLC · Decatur, TNBuilt 1979 · S/N 414A0279 N4725CContinental Aerospace Technologies Inc · Mobile, ALBuilt 1982 · S/N T30300118 N473SLuginbuhl Wayne E · Ormond Beach, FLBuilt 1966 · S/N 310K0131 N474DBMr Restore Services Inc · Vero Beach, FLBuilt 1976 · S/N 310R0822 N474DLPrasad Sanjeev K · Las Vegas, NVBuilt 1976 · S/N 310R0704 N4754AIndigo Air LLC · Gulf Breeze, FLBuilt 1980 · S/N 340A1024 N475JNMiller Aviation LLC · Carrier Mills, ILS/N 414-0917 N475RCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1978 · S/N 4040223 N4763GGamma Transport Solutions Inc · Carrollton, TXFirst renewal noticeBuilt 1977 · S/N 414-0938 N47645Arizona Type Ratings LLC · Sedona, AZBuilt 1980 · S/N 340A0992 N4765GAircraft Charter And Leasing LLC · El Cerrito, CABuilt 1977 · S/N 414-0940 N4772ADodson International Parts Inc · Rantoul, KSS/N 414A0095 N477MGJuliet Delta Aviation LLC · Bozeman, MTBuilt 1973 · S/N 421B0477 N477RSSundbird Airlines Inc · San Juan, PRBuilt 1981 · S/N 402C0477 N4795GAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 414-0949 N4798CKjv Aviation Inc · Brentwood, CAS/N 414-0012 N47AGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1972 · S/N 340-0114 N47BGVonweisenstein Thomas W · Brentwood, TNBuilt 1974 · S/N 310Q1061 N47JDQualitair LLC Trustee · MichelstadtBuilt 1980 · S/N 421C0805 N47KKHermansen Dane K · Ormond Beach, FLBuilt 1983 · S/N T30300216 N47MDBrambles Inc · Bakersfield, CABuilt 1977 · S/N 414-0945 N47NFAndrews University · Berrien Springs, MIS/N 60-6047 N47SPDurham Rex L · Blakely, GABuilt 1969 · S/N 310P0176 N480BWAttitude Aviators Inc · North Myrtle Beach, SCBuilt 1967 · S/N 310L-0137 N4833AEnoch Mark C · Rowlett, TXBuilt 1980 · S/N 340A1026 N4837ALongleaf Wing Ventures LLC · Birmingham, ALBuilt 1978 · S/N 414A0101 N483JFKg Aviation LLC · Huntington, WVBuilt 1974 · S/N 414-0537 N483MMWestern Rivers Aircraft LLC · Paducah, KYBuilt 1977 · S/N 421C0314 N484SWElsass Aviation LLC · Fayetteville, ARBuilt 1980 · S/N 414A0497 N485CBBlue Pathways LLC · Statesville, NCS/N 421C0466 N485DSEncinal Aviation LLC · Springfield, MOBuilt 1978 · S/N 421C0459 N4868AKlokner James B · Madison, WIBuilt 1978 · S/N 310R1393 N486MHMh Group LLC · Duncan, OKBuilt 1978 · S/N 340A0481 N487KMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1977 · S/N 340A0240 N488DMAircraft One Ltd · Grand Rapids, MIS/N 421C-0485

Back to AD 87-21-02 R1