Skip to content

Registered aircraft · 22,413

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-08-08-R3') 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-08-08-R3') 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-08-08-R3')
    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-08-08-R3')
  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-08-08-R3')
  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-08-08-R3')
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.

N4881SGuerin Brian J · Walnut Creek, CABuilt 1970 · S/N 32-7100005 N4881TFuller Aire Inc · Wilmington, DEBuilt 1972 · S/N 28-7205215 N4882LArapahoe Flight Club LLC · Colorado Springs, COBuilt 1967 · S/N 28-4248 N4883LMeixel Aviation LLC · Starbuck, MNBuilt 1967 · S/N 28-4249 N4883SKipp Thomas H · Chardon, OHBuilt 1970 · S/N 32-7100007 N4884SLeto Aviation LLC · Delaware, OHBuilt 1971 · S/N 32-7100008 N4884TRedstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 1972 · S/N 28R-7235131 N4885LMaximize Solutions Inc · Swan Lake, NYBuilt 1967 · S/N 28-4251 N4885SEm & Rb Aviation Group LLC · Tampa, FLBuilt 1971 · S/N 32-7100009 N4886LNortheast Florida Aero Club Inc · Fleming Island, FLBuilt 1967 · S/N 28-4252 N4886SW & K Enterprise LLC · Lewisville, TXFirst renewal noticeBuilt 1971 · S/N 32-7100010 N4887SSlater Michael C · Stillmore, GABuilt 1971 · S/N 32-7100011 N4887TRoe John C · Bonners Ferry, IDS/N 28-7225230 N4888TTevik Michael A · Provo, UTBuilt 1972 · S/N 28-7225231 N4889LWerner Joseph H · Wauconda, ILBuilt 1967 · S/N 28-4255 N4889STiger Wings LLC · Hoover, ALBuilt 1971 · S/N 32-7100013 N4889TS&P Aviation LLC · Albuquerque, NMS/N 28-7205217 N488BLBlue Line Aviation LLC · Smithfield, NCBuilt 2024 · S/N 2881788 N488DJDelta Juliet Holco I LLC · Ocoee, FLBuilt 2025 · S/N 2881981 N488PLutz Brian W · Russellville, ARBuilt 1965 · S/N 28-21081 N4890UUniversity Of Oklahoma · Norman, OKBuilt 2005 · S/N 2842235 N4891LToga LLC · Dayton, VABuilt 1967 · S/N 28-4258 N4891TRoss Stephen C · Santa Fe, NMBuilt 1972 · S/N 28-7205219 N4892SF&G Polk Aviation LLC · Babson Park, FLBuilt 1971 · S/N 32-7140058 N4892TTwo Tango Aviation LLC · Plant City, FLBuilt 1972 · S/N 28R-7235132 N4894LPeairs Gregory Ross · Sacramento, CABuilt 1967 · S/N 28-4261 N4895MPotter Farm Inc · Bolckow, MOS/N 28-7310124 N4895SFoster Bryan A · Malabar, FLBuilt 1971 · S/N 32-7100024 N4896LMike Delta Kilo LLC · Bentonville, ARBuilt 1967 · S/N 28-4263 N4896TVosler Dean S · Bay City, MIBuilt 1972 · S/N 28-7225233 N4897FGnl Aviation LLC · Weatherford, OKFirst renewal noticeBuilt 1976 · S/N 28-7790071 N4899LSweat Larry D · Meridian, IDBuilt 1967 · S/N 28-4266 N4899TAra Airplanes LLC · Richmond, VAS/N 28-7205221 N489BJNo Air Services LLC · Holbrook, NYBuilt 1989 · S/N 2811028 N489CYW Morrison Consulting Group Inc · Aliso Viejo, CABuilt 1973 · S/N 28-7310121 N489PWsi Southwest Inc · Cliff, NMBuilt 1965 · S/N 28-21083 N48CASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2005 · S/N 3246232 N48PRBadrow Allan R · Warrenton, VABuilt 2002 · S/N 2843533 N48VZPrecision Jet Service Inc · Stuart, FLBuilt 1973 · S/N 32-7300044 N48WRRasquinha Warren · Sanford, FLBuilt 1977 · S/N 28R-7703355 N4900JUniversal Technical Institute Inc · Avondale, AZBuilt 1968 · S/N 28R-30617 N4900URegistration Pending · Rockville, MDRegistration pendingBuilt 2005 · S/N 2842240 N4902LObrien William M · Aptos, CABuilt 1967 · S/N 28-4269 N4903LPlane Crazy Aviation LLC · Hollywood, SCBuilt 1967 · S/N 28-4270 N4904JLunken Air Group LLC · Cincinnati, OHS/N 28R-30622 N4904LSchmick David D · Sturgis, MIBuilt 1967 · S/N 28-4271 N4905JMoore Albert III · Las Vegas, NVBuilt 1968 · S/N 28R-30623 N4906JSeal Air LLC · San Juan Capo, CABuilt 1968 · S/N 28R-30624 N4906LRitter Steven L · Harlingen, TXBuilt 1967 · S/N 28-4274 N4906TSmith Bruce · Leonardtown, MDBuilt 1972 · S/N 28R-7235158

Back to AD 87-08-08 R3