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.

N4434JCarney Allen G · Weaubleau, MOBuilt 1967 · S/N 28-22838 N4434XLusher Frank W II · Prichard, WVBuilt 1975 · S/N 28R-7635041 N44355Registration Pending · Augusta, KSRegistration pendingBuilt 1974 · S/N 28-7415625 N44363Good Flight Aviation LLC · Stockton, CABuilt 1974 · S/N 28-7415626 N44369T&B Aviation LLC · Rancho Cucamonga, CAS/N 32-7440151 N4437SVenture West LLC · Mesa, AZBuilt 2015 · S/N 2844156 N4437WVenture West LLC · Mesa, AZBuilt 2015 · S/N 2844157 N4437XMarianas Air Transfer Inc · Saipan, MPBuilt 1975 · S/N 28-7625032 N44383B2w Corporation · Winona, MNBuilt 1974 · S/N 28-7415628 N44388Zavoda Scott E · Strongsville, OHBuilt 1974 · S/N 28R-7435307 N4438DMa Aviation LLC · Danville, ILBuilt 2015 · S/N 2844158 N44397Tsfc Inc · Angola, INBuilt 1974 · S/N 28-7425408 N44399Glass Robert S Trustee · Costa Mesa, CABuilt 1974 · S/N 28-7415631 N4439XMccormick Robert E · Yakima, WABuilt 1975 · S/N 28R-7635043 N443FLPradhan Anis · Torrance, CABuilt 1971 · S/N 28-7125234 N443PABird Acquisition LLC · Phoenix, AZBuilt 2001 · S/N 2843499 N44400Vonditsianou Michalis · Milpitas, CABuilt 1974 · S/N 28-7405239 N44407Kroneck Timothy S · Plymouth, WIBuilt 1974 · S/N 28-7425409 N4440TBadger Western Exploration Inc · Silver City, NMBuilt 1972 · S/N 28-7210010 N44411Ruiz Raul · Sugar Land, TXBuilt 1974 · S/N 28-7415633 N44412J Mar Corp · Pittsburgh, PABuilt 1974 · S/N 28-7415634 N44413Premier Capital Enterprises LLC · Hurricane, UTBuilt 1974 · S/N 28-7405241 N4441JPinkston Lance C · Batesville, ARBuilt 1967 · S/N 28-22846 N44420England James M · West Paducah, KYBuilt 1974 · S/N 28-7415635 N44421Rojas Alissa · Warwick, RIBuilt 1974 · S/N 28-7415636 N44426Skyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842396 N44429Bettencourt David A · Dayville, CTBuilt 1974 · S/N 28-7415638 N4442XHayes Kevin R · Richmond Hill, GABuilt 1975 · S/N 28-7625034 N44430Red Eye Aviation LLC · Minocqua, WIBuilt 1974 · S/N 28-7405242 N4443QSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842397 N4443TKristofzski John · West Richland, WABuilt 1971 · S/N 28-7105228 N4443XFox Two LLC · Camino, CABuilt 1975 · S/N 28R-7635044 N44442Cummins Stephen Michael · Fenton, MOBuilt 1974 · S/N 28-7405244 N44443Jax Navy Flying Club · Jacksonville, FLBuilt 1974 · S/N 28R-7535001 N4444EIllsley Roger J · Santa Rosa, CABuilt 1976 · S/N 28-7690250 N44450Brown Roy A · Morongo Valley, CABuilt 1974 · S/N 28-7425412 N44452Cdr Aviation LLC · Kalispell, MTS/N 28-7425413 N44458Forsman Airways LLC · Glenwood, MNBuilt 1974 · S/N 28R-7435309 N4445JSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842398 N4445KSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842399 N4445PSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842400 N4445SSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842401 N4445VSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842402 N4445XRegistration Pending · Midlothian, TXRegistration pendingBuilt 1975 · S/N 32R-7680017 N4445YSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842403 N4446JScherr Steven · Mandan, NDBuilt 1967 · S/N 28-22850 N44478Richard J Farmer II · Fremont, OHBuilt 1974 · S/N 28-7405247 N4447DWehmacher James P · Crawford, COS/N 28-10621 N44485Registration Pending · Middletown, OHRegistration pendingS/N 28-7415646 N44488Daris James · Fitzwilliam, NHBuilt 1974 · S/N 28-7415647

Back to AD 87-08-08 R3