Skip to content

Registered aircraft · 54,017

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-20-03-R2') 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-20-03-R2') 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-20-03-R2')
    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-20-03-R2')
  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-20-03-R2')
  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-20-03-R2')
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.

N50641Jstram Lc · Sheridan, WYBuilt 1968 · S/N 15069454 N5064DPershing Flying Club Inc · Lovelock, NVBuilt 1958 · S/N 51164 N5064HFranklin Air Services LLC · New Orleans, LABuilt 1975 · S/N 17265325 N50652Omlid Robert L · Watford City, NDBuilt 1968 · S/N 15069461 N5065DWharton Edwin Scott · Anchorage, AKBuilt 1958 · S/N 51165 N5065ERickman Wanda M · Absarokee, MTBuilt 1958 · S/N 50365 N50663Zimna Grazyna · KrasocinS/N 15069467 N50665Meneely Robert W · Los Altos Hills, CAS/N 15069469 N5066AThordarson Norman K · Friday Harbor, WABuilt 1955 · S/N 28066 N5066DCurry Timothy S · Salisbury, MDBuilt 1958 · S/N 51166 N5066RBurke William M · Norwalk, CTBuilt 1974 · S/N 17263304 N50672Registered aircraftBuilt 1968 · S/N 15069476 N50679Go Fly Ez LLC · Athens, OHBuilt 1968 · S/N 15069480 N5067ADaniels Tim · Unalakleet, AKBuilt 1955 · S/N 28067 N5067ERickenbach Rodd L Trustee · Denver, COBuilt 1958 · S/N 50367 N5067HSanders Flight Training Center Inc · Jasper, ALS/N 17265326 N50688Hershey Andrew C · Manchester, NHBuilt 1968 · S/N 15069485 N50691Layka'S Choice LLC · Lawrenceville, GABuilt 1968 · S/N 15069487 N50695Mannfolk Steven M · Wingdale, NYS/N 15069489 N50696Winsor Andrew · Medford, MAS/N 15069490 N50697Cole Timothy Les · Las Vegas, NVBuilt 1968 · S/N 15069491 N5069ANusz Russell I · Hitchcock, OKBuilt 1953 · S/N 28069 N5069HNehring Curtis A · Goleta, CABuilt 1975 · S/N 17265327 N506DEAero Fliers LLC · Kalispell, MTBuilt 1977 · S/N 15279717 N506YZR&R Gray Equipment & Cattle LLC · Enid, OKS/N 21059139 N50704Fox Valley Technical College · Oshkosh, WIBuilt 1968 · S/N 15069496 N50706Rhoades Charles E · Blessing, TXFirst renewal noticeS/N 15069498 N50717Road Robert L · Fargo, NDBuilt 1968 · S/N 15069504 N5071AMccanles Mike E · Adrian, MOBuilt 1955 · S/N 28071 N5071DAcmx LLC · Cedar Rapids, IAS/N 51171 N5071HFosse David K · Carbondale, ILS/N 17265329 N50720Smith Bruce Allan · Phelps, KYBuilt 1968 · S/N 15069506 N50728Erickson Aeronautics LLC · Perry, IABuilt 1968 · S/N 15069512 N50729Blue Sky 6 LLC · Torrance, CAS/N 15069513 N5072AGibbs James P · Boerne, TXS/N 28026 N5072GRuffaire LLC · Midland, TXS/N R1720205 N5072HRiebeling Eric Herbert · Reno, NVBuilt 1975 · S/N 17265330 N5072UStopka Alexis L · Belgrade, MTFirst renewal noticeBuilt 1963 · S/N 206-0072 N50732Lil 150 LLC · Sauk Rapids, MNBuilt 1968 · S/N 15069515 N50734Dillman Kurt A · Victor, NYBuilt 1968 · S/N 15069517 N5073HElite Planes LLC · Menifee, CAS/N 17265331 N5073NPavco Inc · Gig Harbor, WABuilt 1985 · S/N 17276404 N5073RMckenna Brothers Aircraft LLC · Anchorage, AKBuilt 1976 · S/N 18502997 N50745Caicedo David · Villa Rica, GABuilt 1968 · S/N 15069524 N50747N50747 LLC · Great Falls, MTBuilt 1968 · S/N 15069526 N50748Freeman Teresa L · Kinston, OHBuilt 1968 · S/N 15069527 N50749Blackwater Aviation LLC · Douglas, GABuilt 1968 · S/N 15069528 N5074DAhumada George · Palmer, AKBuilt 1958 · S/N 51174 N5074EKauffman Stephen E · Anchorage, AKS/N 50374 N50750Christensen William A · Dallas, TXBuilt 1968 · S/N 15069529

Back to AD 87-20-03 R2