Skip to content

Registered aircraft · 6,916

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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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.

N55907Gregg Jeffrey B · Sun Valley, CAS/N 28R7335309 N5590PUdall Thomas H · Mckinney, TXBuilt 1958 · S/N 24-656 N55919Northstar Group LLC · Dothan, ALBuilt 1973 · S/N 28R-7335312 N55928Tao Aviation LLC · Las Vegas, NVS/N 34-7350261 N5592PWelch Roy T · Garfield, WABuilt 1959 · S/N 24-658 N55935Teprovich Thomas J III · Peachtree City, GABuilt 1973 · S/N 28R-7335313 N5593PDingus Donald E Jr · Brownfield, TXBuilt 1959 · S/N 24660 N55948N235ml LLC · Marshalltown, IABuilt 1973 · S/N 28R-7335316 N55958Rl Magneto LLC · Sacramento, CABuilt 1973 · S/N 28R-7335317 N5595VDawkins James P · Aurora, COS/N 28R-7703133 N55960Gallagher Sean · Cave Creek, AZBuilt 1973 · S/N 28R-7335318 N55970Soaring Eagle Aviation LLC · Carmi, ILBuilt 1973 · S/N 34-7350266 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 N55AGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1965 · S/N 30-804 N55CYBonneville Aero Works LLC · Greenville, SCBuilt 1961 · S/N 24-2674 N55LMQuinn Sean · Edmonds, WABuilt 1977 · S/N 28R-7703258 N55RDSchober David · Union Bridge, MDBuilt 1966 · S/N 30-1307 N56000Wings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 34-7350270 N5600PBfi Inspections LLC · Nevada City, CAS/N 24681 N5601PDevil Dusters Inc · Artesia, NMS/N 24-669 N56023Bennett Paul · Phoenix, AZBuilt 1973 · S/N 28R-7335336 N5602VBam Aviation LLC · Celina, TXS/N 32R-7780345 N56031Musser John R · Freeport, ILBuilt 1973 · S/N 28R-7335338 N56032Umo Flight School LLC · Mount Olive, NCBuilt 1973 · S/N 28R-7335339 N5603PLitteken David T · Aviston, ILBuilt 1959 · S/N 24-671 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 N5611PWeyland Aviation Inc · Lewes, DEBuilt 1959 · S/N 24-679 N56129Skurzynski James S · Santa Ana, CABuilt 1973 · S/N 28R-7335361 N5612PClarity Aviation LLC · Boise, IDBuilt 1959 · S/N 24-680 N56130Flying Aces Aero-Fleet Inc · Guyton, GABuilt 1973 · S/N 28R-7335362 N56141Simmerer Stephen J · Allenton, MIBuilt 1973 · S/N 28R-7335364 N5614PShetty Balakrishna · Wesley Chapel, FLBuilt 1959 · S/N 24-682 N5616PKallenberger Ross A · Bakersfield, CABuilt 1959 · S/N 24-684 N5617PBuchheit Dirk · Lake Worth, FLBuilt 1959 · S/N 24-685 N56191Twedt Jeffrey Lee · Montrose, SDS/N 28R-7335379 N56211Bergstrom Aircraft Inc · Pasco, WABuilt 1973 · S/N 28R-7335384 N56213Elite Florida Ac LLC · Titusville, FLBuilt 1973 · S/N 347350304 N5622PBaker Franklin E · Montgomery, ILBuilt 1959 · S/N 24-691 N5623VRedland Aviation LLC · Plain Dealing, LAFirst renewal noticeBuilt 1977 · S/N 28R-7703137

Back to AD 97-01-01 R1