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.

N384HSClear Prop LLC · Murfreesboro, TNBuilt 1977 · S/N 28-7790550 N384NDJmfb Enterprises LLC · Concord, NCBuilt 2003 · S/N 2844095 N38505Commercial Openings · Raleigh, NCBuilt 1977 · S/N 28-7911001 N38509Fitzgerald Brady · St Augustine, FLBuilt 1977 · S/N 32R-7780435 N38513J&L Aviation LLC · Wilmington, DEBuilt 1977 · S/N 28-7725284 N38517Stillway Dennis Trustee · Vallejo, CABuilt 1977 · S/N 28-7790558 N3851RIriana Arthur · Palmdale, CABuilt 1970 · S/N 28-5840 N3851TSkyview Aviation LLC · Tracy, CABuilt 1967 · S/N 28R-30173 N38522Radcliffe Joshua Kyle · Atlanta, GAS/N 28-7816180 N3852TB & B Aircraft LLC · Norcross, GABuilt 1967 · S/N 28R-30174 N3852WHaymond David G · Sandy, UTBuilt 1966 · S/N 32-792 N38538Jurecka Joseph W · Lubbock, TXBuilt 1977 · S/N 28R-7703237 N38539Sale Reported · KyivSale reportedBuilt 1977 · S/N 28R-7703238 N3853RDimichele James Jr · Ronkonkoma, NYBuilt 1970 · S/N 28-5844 N38549Cohesive Aviation LLC · Gilford, NHS/N 28-7716268 N3854WValiair Lc Trustee · Casper, WYBuilt 1966 · S/N 32-795 N38553Cherry Hill Aviation Inc · Freetown, INBuilt 1977 · S/N 28-7790563 N38555Grimm Chris · Burlington, IABuilt 1977 · S/N 28R-7703239 N38557Bowyer Ronald D · Keene, TXBuilt 1977 · S/N 28R-7703242 N3855MPramik Edward J · Norton, OHBuilt 1978 · S/N 28-7816381 N3855TEskridge William M · Cheraw, SCBuilt 1967 · S/N 28R-30178 N3855WRcr Aviation LLC · Punta Gorda, FLBuilt 1968 · S/N 32-1057 N38562Adventures Awaiting LLC · Rogers, ARBuilt 1977 · S/N 32R-7780442 N38564Ck Leasing Services LLC · Wilmington, DEBuilt 1977 · S/N 28R-7737097 N38565Olson Michael S · Ellsworth, KSFirst renewal noticeBuilt 1977 · S/N 28R-7737098 N3856TB & B Flying LLC · Huntingburg, INBuilt 1967 · S/N 28R-30179 N3856WBarr Barry · Memphis, TNBuilt 1966 · S/N 32-797 N38575Hieb Jared · Amarillo, TXBuilt 1977 · S/N 32R-7780444 N38577Global Aviation Corp · Farmingdale, NYBuilt 1977 · S/N 28-7716201 N38578H & H Contracting And Lease Services Inc · Midlothian, ILBuilt 1977 · S/N 28-7725256 N3857TAmt Services LLC · Virginia Beach, VABuilt 1967 · S/N 28R-30180 N38580Avier LLC · Beverly, MABuilt 1977 · S/N 28-7725286 N38587Swihart Painting LLC · Bolivar, MOBuilt 1977 · S/N 28R-7737100 N3858MMachias Auto Parts Inc · Jonesport, MEBuilt 1978 · S/N 28-7816628 N3858TFlying Dots LLC · Daytona Beach, FLBuilt 1967 · S/N 28R-30181 N38594Vineyard David D Md · South Lake, TXBuilt 1977 · S/N 28R-7703249 N38597Bad Dog Aviation Inc · Meridianville, ALBuilt 1977 · S/N 32R-7780445 N38599Collum Aviation LLC · Milton, FLS/N 28-7716271 N3859MWhite Roger L · Wallins Creek, KYS/N 28-7890336 N3859TYurek Allen L · Fairfax, VABuilt 1967 · S/N 28R-30182 N3859WFast Lane Aviation Lllp · Hawkinsville, GAFirst renewal noticeBuilt 1966 · S/N 32-801 N385DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843847 N385HPAgri-Land West LLC · Newton, NCBuilt 2007 · S/N 3257467 N38603Flight Share LLC · Charlotte, NCBuilt 1977 · S/N 28-7790570 N38605Registration Pending · Kalispell, MTRegistration pendingBuilt 1977 · S/N 28R-7737102 N3860RLundgren Christopher B · Graham, TXBuilt 1970 · S/N 28-5833 N3860TTds Property Holdings LLC · Gilmer, TXBuilt 1967 · S/N 28R-30183 N3860WBrasfield Jason · Bonnerdale, ARBuilt 1966 · S/N 32-802 N38610Whiskey Tango Foxtrot Aviation LLC · Broomfield, COS/N 28R-7703252 N38617Bros Flying Low LLC · Kalispell, MTS/N 32R-7780447

Back to AD 87-08-08 R3