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.

N558SMTsvang Volodymyr · Redondo Beach, CABuilt 1975 · S/N 28-7505130 N55905Top Coat Takeoff LLC · Cincinnati, OHBuilt 1973 · S/N 28-7305496 N55907Gregg Jeffrey B · Sun Valley, CAS/N 28R7335309 N5590FLee A Archer Jr Red Tail Youth Flying Progrom Inc · New Windsor, NYS/N 28-24923 N5590JWilliams John S · Cleveland, TXBuilt 1968 · S/N 32-1050 N55913Buckner Business Services Inc · Trenton, MOBuilt 1973 · S/N 28-7305497 N55915Loncella James G · Johnstown, PABuilt 1973 · S/N 28-7305500 N55919Northstar Group LLC · Dothan, ALBuilt 1973 · S/N 28R-7335312 N5591WMontag Mark W · Pine River, WIBuilt 1962 · S/N 28-794 N55920Gillbreath Monty Everett · Livingston, TXS/N 28-7325529 N55925Goodwin Collin H · Hobbs, NMS/N 28-7325532 N5592FEagle Air Flying Club Inc · Bowling Green, OHBuilt 1968 · S/N 28-24879 N5592JHyden Josh Vander · Beulah, MIBuilt 1968 · S/N 32-1056 N5592VBlack Dog Air LLC · Satellite Beach, FLBuilt 1977 · S/N 28-7790482 N55930Lafrance Troy R · Paola, KSBuilt 1973 · S/N 28-7325534 N55932Red Eagle Aviation LLC · Deridder, LABuilt 1973 · S/N 28-7305503 N55933Knoxville Aviation · Knoxville, IAS/N 28-7305504 N55934Roloff Paul E Trustee · Waupaca, WIBuilt 1973 · S/N 28-7305505 N55935Teprovich Thomas J III · Peachtree City, GABuilt 1973 · S/N 28R-7335313 N55938Turner Cole M · Round Rock, TXBuilt 1973 · S/N 287325536 N55940Zadrick Wayne J · Bristol, CTBuilt 1973 · S/N 28-7325537 N55942Ray Lynn M · Cloquet, MNBuilt 1973 · S/N 28-7325538 N55948N235ml LLC · Marshalltown, IABuilt 1973 · S/N 28R-7335316 N5594JGirdler Robert L · Sunrise, FLBuilt 1968 · S/N 32-1061 N55954Registration Pending · Jacksonville, FLRegistration pendingBuilt 1973 · S/N 28-7325539 N55955Pierce Riley Deirdre · Chicago, ILBuilt 1973 · S/N 28-7325542 N55957Blumie Thomas C · Jewett City, CTBuilt 1973 · S/N 32-7340148 N55958Rl Magneto LLC · Sacramento, CABuilt 1973 · S/N 28R-7335317 N5595FByrne Matthew A · West Allis, WIBuilt 1968 · S/N 28-24883 N5595VDawkins James P · Aurora, COS/N 28R-7703133 N55960Gallagher Sean · Cave Creek, AZBuilt 1973 · S/N 28R-7335318 N55965Greene County Flying Club · Waynesburg, PABuilt 1973 · S/N 28-7305510 N55967Hisman Gary L · Skagway, AKS/N 28-7305511 N5596JJenny LLC · Hudsonville, MIBuilt 1968 · S/N 32-1037 N5596UPine Aviation Inc · Sheridan, WYBuilt 1969 · S/N 28-26326 N55973Crase Nicole Trustee · Mansfield, OHBuilt 1973 · S/N 28-7325543 N55975Pena Leonardo · The Colony, TXBuilt 1973 · S/N 28-7325545 N55977Walker Benjamin M · Weatherford, TXBuilt 1973 · S/N 28-7305512 N55979Acumen Aerotech LLC · Rogers, TXBuilt 1973 · S/N 28R-7335321 N5597FDeardorff Karl R · San Luis Obispo, CABuilt 1968 · S/N 28-24853 N5597UFejor Inc · San Juan, PRBuilt 1969 · S/N 28-26327 N5597WLathrop Christopher A · Palmyra, WIBuilt 1962 · S/N 28-733 N55986Turner Jeffrey K · Gastonia, NCBuilt 1973 · S/N 28R-7335322 N55988Murawski Rene · Clarkston, MIBuilt 1973 · S/N 28-7325549 N5598FKeran Gary R · New Holstein, WIBuilt 1976 · S/N 28-7725064 N5598JMakfly LLC · Chardon, OHBuilt 1968 · S/N 32-1065 N5598UHilton Colby W · Amarillo, TXBuilt 1969 · S/N 28-26328 N5598WBall Dontel J · Tacoma, WAS/N 28-734 N55990Registered aircraftN-number assigned, not yet registeredS/N 28R-7335323 N55996Mcfarlane Randall C · Loudonville, NYBuilt 1973 · S/N 28R-7335325

Back to AD 87-08-08 R3