Skip to content

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.

N812SRVantage Point Northwest Aviation LLC · Sheridan, WYBuilt 1979 · S/N 414A0326 N812VLa Plane LLC · Fort Thomas, AZBuilt 1972 · S/N 340-0157 N8131QClub Jet Investments LLC · Wilmington, DES/N 414-0031 N8133QFinnan-Johnson Flying Club LLC · Woodinville, WABuilt 1972 · S/N 310Q0626 N8134QPaul Morrill Excavating Inc · Newcastle, CABuilt 1969 · S/N 414-0034 N8136ZUniversity Of Alaska Anchorage · Anchorage, AKS/N 31010004 N8139MAcme Racing LLC · Overland Park, KSBuilt 1964 · S/N 310I0139 N8141MTerry Jan Chester · Beverly Hills, FLBuilt 1964 · S/N 310I0141 N8144QOcf Air LLC · Phoenix, AZBuilt 1970 · S/N 414-0044 N8145QWestern Nebraska Community College · Scottsbluff, NES/N 414-0045 N8147MDe La Rosa Sergio · Nogales, AZBuilt 1964 · S/N 310I0147 N814SWWenman Bradford Harris · Johnson, KSS/N 340-0197 N8150QSouthern Journey LLC · South Padre Island, TXS/N 414-0050 N8151QMiller James A Md · Merino, COS/N 414-0051 N8155ASkylane Ventures LLC · Keizer, ORS/N 310R0025 N815ACHakes Thomas A · Suring, WIBuilt 1975 · S/N 310R0597 N8166MMagafly LLC · Bay City, MIS/N 310I0166 N8166QE S P Aviation LLC · Wilmington, DEBuilt 1972 · S/N 310Q0633 N8167MFrick Richard W · Sidell, ILBuilt 1964 · S/N 310I0167 N8168MWilliams Charles S · Kingwood, TXBuilt 1964 · S/N 310I0168 N816GHSteim Joseph M · Shirley, MABuilt 1978 · S/N 310R1507 N816LHL Howard Construction Inc · Abernathy, TXS/N 421B0565 N8175QMillenium Enterprises LLC · Naples, FLS/N 340-0522 N8177MSouthern Sky Enterprises LLC · Lafayette, LABuilt 1964 · S/N 310I0177 N8178MAcevedo Xochil · San Antonio, TXS/N 310I0178 N8179QCruce Aircraft Services LLC · Clewiston, FLBuilt 1972 · S/N 310Q0635 N817GCMountain View Aeromotive Inc · Del Norte, COBuilt 1975 · S/N 310R0264 N817JPOdom Johnny C · Fredericksburg, TXBuilt 1976 · S/N 414-0850 N817LLJg Aero LLC · Clermont, FLS/N 421C0230 N8181GAirplane LLC · Coeur D Alene, IDS/N 421C0302 N8184MAndrey Granin · Wantagh, NYBuilt 1964 · S/N 310I0184 N8184QJohn Richard A · Southwest Ranches, FLBuilt 1972 · S/N 310Q0636 N8188QI Will Rise LLC · Chattanooga, TNBuilt 1972 · S/N 310Q0638 N818AKWhirley Robert G · Santa Rosa, CABuilt 1981 · S/N 421C1085 N818ANBank Of Utah Trustee · Salt Lake City, UTBuilt 1981 · S/N 402C0501 N818DHCouch Fred · Fort Worth, TXS/N 421C0840 N818TKInternational Air Services Inc Trustee · Carson City, NVBuilt 1980 · S/N 421C0873 N818XJays Aircraft Maintenance Inc · Costa Mesa, CAS/N 421C1021 N8191MWalters Larry C · Wasilla, AKBuilt 1964 · S/N 310I0191 N8195MPeed Robert M · Gilbert, AZBuilt 1964 · S/N 310I0195 N8195QD&M Enterprise LLC · Wilmington, DEBuilt 1970 · S/N 414-0095 N819RARonald Jinsky LLC · Beloit, WIBuilt 1978 · S/N 421C0522 N81ADMr Dent Inc · Manheim, PAS/N 401A0023 N81LPSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1981 · S/N 421C-1083 N81NNNona Tech LLC · Orlando, FLBuilt 1964 · S/N 320C0025 N81RDPapaco LLC · Green Cove Springs, FLS/N 421C0291 N81RTN81rt LLC · Middlebury, CTBuilt 1973 · S/N 310Q0742 N81RYRedding Dermatology Medical Group Inc · Redding, CABuilt 1981 · S/N 340A1238 N81WAAdmiral Aviation Inc · New Castle, DEBuilt 1976 · S/N 310R0693 N821BTN821bt Aviation LLC · Dover, DEBuilt 1978 · S/N 310R1298

Back to AD 87-21-02 R1