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.

N5211PCedar Mark P · Cherokee, IABuilt 1958 · S/N 24-236 N5213THess Garrett J · Fullerton, CABuilt 1972 · S/N 34-7250222 N5217PLevezow Steven M · Manawa, WIBuilt 1958 · S/N 24-244 N5217TJahangiri Ali · Arlington, TXBuilt 1972 · S/N 28R-7235198 N521KBJuggyjet Airways LLC · Weehawken, NJBuilt 1978 · S/N 34-7870384 N521MWGruetzmacher Marcus Collin · Denton, TXFirst renewal noticeBuilt 1960 · S/N 24-1978 N5220PStancil Thomas E III · Winterville, NCBuilt 1958 · S/N 24-247 N5222PGharazeddine Raja N · Kaplan, LABuilt 1958 · S/N 24-249 N5225THolt Joseph · Farmington, MOBuilt 1972 · S/N 28R-7235199 N5226PGoodin Jacob P · Knob Noster, MOBuilt 1958 · S/N 24-256 N5227PBranch Antonio D · Lakewood, OHBuilt 1958 · S/N 24-257 N5228PFtf Group LLC · Galt, CABuilt 1958 · S/N 24-258 N5228TWhytes Inc · Coconut Creek, FLBuilt 1972 · S/N 34-7250226 N5229TParker Edward Milton Jr · Griffin, GABuilt 1972 · S/N 28R-7235002 N522CBVancil Jon D · Collierville, TNBuilt 1960 · S/N 24-1939 N522TJMathis Michael W · Miller, MOBuilt 1959 · S/N 24-1130 N522WRegistration Pending · Valparaiso, INRegistration pendingBuilt 1958 · S/N 24377 N5230PMeyer Richard S · El Paso, TXBuilt 1958 · S/N 24-260 N5234PLevay Brad A · Mohave Valley, AZS/N 24-264 N5236PCheyne Dewolfe · Cave Creek, AZS/N 24-266 N5239PWall Robert D · Ocala, FLBuilt 1958 · S/N 24-270 N5240PWeber Rodney D · Apple Valley, CABuilt 1958 · S/N 24-271 N5242PPennacchio Leo Trustee · Santa Rosa, CABuilt 1958 · S/N 24-273 N5243PR & O Aviation LLC · Middleville, MIBuilt 1958 · S/N 24-274 N5246PYoyodyne Group Inc · Wilmington, DES/N 24-277 N5248PKnox Edward R · Gulfport, MSBuilt 1958 · S/N 24-279 N5249TTri-Angle Aviation LLC · Henderson, KYBuilt 1972 · S/N 28R-7235204 N524MFunny Penguin LLC · North Canton, OHBuilt 1969 · S/N 28R-31101 N524PAm Utilities & Construction LLC · Palmhurst, TXBuilt 1969 · S/N 28R-35263 N5250TMedlaw Aviation LLC · Temple, TXS/N 28R-7235206 N5251PTaflinger Bradley P · Clarkdale, AZS/N 24-283 N5252PBrannan Andrew · Texarkana, ARBuilt 1958 · S/N 24-284 N5252TRunway Aviation Flight Training USA Corp · Rockwall, TXBuilt 1972 · S/N 34-7250232 N5253PSale Reported · Greeley, COSale reported, pending cancellationS/N 24-285 N5257PAero Nautics Inc · Cheyenne, WYS/N 24-289 N5258PMosley Hardy · Elko, NVBuilt 1958 · S/N 24-290 N5259PPacheco Carlos Antonio · Yuma, AZBuilt 1958 · S/N 24-293 N525JFMoray Eel LLC · Vail, AZS/N 24-4905 N525QSugai Kunio K · Van Nuys, CABuilt 1975 · S/N 34-7670089 N525RJValiair Limited Company Trustee · Casper, WYBuilt 1977 · S/N 32R7780278 N525VBLincoln Robert D · Bedminster, NJFirst renewal noticeBuilt 1978 · S/N 28R-7837287 N525WARegistered aircraftBuilt 1979 · S/N 34-8070005 N5261PMon-Dak Consulting Inc · Plentywood, MTFirst renewal noticeBuilt 1958 · S/N 24-297 N5262TSmith Gregory W · Laurel, MDBuilt 1972 · S/N 28R-7235210 N5264PBohmer James F · Tulsa, OKS/N 24-300 N5266SFogle Cooper · Mooresville, NCBuilt 1971 · S/N 28R-7135120 N5271TOracle Aviation LLC · Omaha, NEBuilt 1972 · S/N 28R-7235212 N5272PBombach James · Katy, TXBuilt 1958 · S/N 24-311 N5273PSouthern View Energy Inc · Lula, GABuilt 1958 · S/N 24-312 N5278PRoebuck David M · Hamilton, GABuilt 1958 · S/N 24-317

Back to AD 97-01-01 R1