Skip to content

Registered aircraft · 1,753

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:81-11-02-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-11-02-R1') 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:81-11-02-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-11-02-R1')
  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:81-11-02-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-11-02-R1')
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.

N55804Angert Phillip · Linden, NJBuilt 1973 · S/N 28R-7335291 N55821Dildy Douglas C · Albuquerque, NMBuilt 1973 · S/N 28R-7335295 N55830Rudd Clark David · Sheboygan Falls, WIBuilt 1973 · S/N 28R-7335296 N55837Mcqueen Bill · Turlock, CAS/N 28R-7335298 N55855Caspersen Lars · Bloomsburg, PAS/N 28R-7335301 N55885Massa Paul G · Windsor Locks, CTBuilt 1973 · S/N 28R-7335305 N55907Gregg Jeffrey B · Sun Valley, CAS/N 28R7335309 N55919Northstar Group LLC · Dothan, ALBuilt 1973 · S/N 28R-7335312 N55935Teprovich Thomas J III · Peachtree City, GABuilt 1973 · S/N 28R-7335313 N55948N235ml LLC · Marshalltown, IABuilt 1973 · S/N 28R-7335316 N55958Rl Magneto LLC · Sacramento, CABuilt 1973 · S/N 28R-7335317 N55960Gallagher Sean · Cave Creek, AZBuilt 1973 · S/N 28R-7335318 N55979Acumen Aerotech LLC · Rogers, TXBuilt 1973 · S/N 28R-7335321 N55986Turner Jeffrey K · Gastonia, NCBuilt 1973 · S/N 28R-7335322 N55990Registered aircraftN-number assigned, not yet registeredS/N 28R-7335323 N55996Mcfarlane Randall C · Loudonville, NYBuilt 1973 · S/N 28R-7335325 N56023Bennett Paul · Phoenix, AZBuilt 1973 · S/N 28R-7335336 N56031Musser John R · Freeport, ILBuilt 1973 · S/N 28R-7335338 N56032Umo Flight School LLC · Mount Olive, NCBuilt 1973 · S/N 28R-7335339 N56050Seidel Seth · Ellington, CTBuilt 1973 · S/N 28R-7335340 N56063Powell James M III · Columbia, SCBuilt 1973 · S/N 28R-7335344 N56066Trojan Aviation LLC · Kailua Kona, HIBuilt 1973 · S/N 28R-7335346 N56085Donohue John T · Big Bear Lake, CABuilt 1973 · S/N 28R-7335348 N56086Cacolici Dominic · Saint Petersburg, FLBuilt 1973 · S/N 28R-7335349 N560BYShogbonyo Michael A · Arlington, TXBuilt 1973 · S/N 28R-7335333 N56101Seniram Air Inc · Wilmington, DEBuilt 1973 · S/N 28R-7335354 N56114Anderson Douglas · Queen Creek, AZS/N 28R-7335357 N56115Schenck Christopher R · The Woodlands, TXBuilt 1973 · S/N 28R-7335358 N56129Skurzynski James S · Santa Ana, CABuilt 1973 · S/N 28R-7335361 N56130Flying Aces Aero-Fleet Inc · Guyton, GABuilt 1973 · S/N 28R-7335362 N56141Simmerer Stephen J · Allenton, MIBuilt 1973 · S/N 28R-7335364 N56191Twedt Jeffrey Lee · Montrose, SDS/N 28R-7335379 N56211Bergstrom Aircraft Inc · Pasco, WABuilt 1973 · S/N 28R-7335384 N56247Aviair Corp · Tequesta, FLBuilt 1973 · S/N 28R-7335391 N56264Fingerlakes Aviation LLC · Marietta, NYBuilt 1975 · S/N 28R-7535212 N56283Stephens Donald K · Modesto, CABuilt 1973 · S/N 28R-7335399 N56313Markel John E · Sussex, NJBuilt 1973 · S/N 28R-73-35407 N56317Flying Doctor LLC · Clearwater, FLBuilt 1973 · S/N 28R-7335410 N56326Abernathy Spraying Service Inc · Tipton, OKBuilt 1973 · S/N 28R7335409 N56339N56339 LLC · Lebanon, OHBuilt 1973 · S/N 28R7335414 N56353Groux Zachary Brian · Spring, TXBuilt 1973 · S/N 28R7335418 N56355Vectair USA LLC · Olive Branch, MSBuilt 1973 · S/N 28R7335419 N56390Renard Jerome L Trustee · Curtis, NEBuilt 1973 · S/N 28R-7335431 N563CARegistration Pending · Wilmington, DERegistration pendingBuilt 1975 · S/N 28R-7535275 N563PJMcdonald Patrick J · Des Moines, IABuilt 1973 · S/N 28R-7335411 N563SBWalker Linda V · Zeeland, MIBuilt 1973 · S/N 28R-7335429 N56410Ehrler Andrew N · Flushing, NYS/N 28R-7335433 N56418Shepler John E · Mobile, ALBuilt 1973 · S/N 28R7335434 N56440Registration Pending · Wilmington, NCRegistration pending, pending cancellationS/N 28R7335437 N56453Richard G Trudeau LLC · Alto, TXBuilt 1973 · S/N 28R-73-35439

Back to AD 81-11-02 R1