Skip to content

Registered aircraft · 40,474

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:80-04-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:80-04-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:80-04-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:80-04-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:80-04-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:80-04-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.

N13515412 Jw Aviation LLC · Dover, DEBuilt 1976 · S/N 17702431 N1351CSapphire Vistas LLC · Iowa City, IAFirst renewal noticeBuilt 1977 · S/N 17702708 N1351EJ & S Air Ventures LLC · Eagle Lake, FLBuilt 1978 · S/N 17270965 N1351UThomas Jackson Smith · Baton Rouge, LAS/N 17267022 N1351WAllen Mark S · Reno, NVBuilt 1963 · S/N 2632 N13521Ekberg Jeff M · Emmett, IDS/N 17262817 N13522Recker Edward J · Surprise, AZBuilt 1973 · S/N 17262818 N13524Loomis Avaition LLC · Columbus, OHBuilt 1973 · S/N 17262820 N13526Rolla Aero Inc · Rolla, NDBuilt 1976 · S/N 17702433 N13527Beekman Gary J · Oconto, WIBuilt 1973 · S/N 17262823 N13529Meyer Ricky L · New Liberty, IABuilt 1973 · S/N 17262825 N1352EMclv2020 LLC · Las Vegas, NVBuilt 1978 · S/N 17270966 N1352PHouse Travis · Bristow, VABuilt 1955 · S/N 23-401 N1352UN19630 LLC · Fort Collins, COBuilt 1976 · S/N 17267023 N13535Aviation Academy LLC · Wichita, KSS/N 17262830 N13537Sale Reported · Brownsville, ORSale reported, pending cancellationBuilt 1973 · S/N 17262832 N13539Pawul Frank A · Graham, WABuilt 1973 · S/N 17262833 N1353CMason Teresa J · Tucson, AZBuilt 1977 · S/N 17702709 N1353NSubsonic Aviation Leasing LLC · Grandville, MIBuilt 1979 · S/N AA5B1242 N1353UReynolds Darryl G · Wills Point, TXBuilt 1976 · S/N 17267024 N1353YRust Joyce A · Bourbon, INBuilt 1974 · S/N 28-7405152 N13540Spangler Taylor L · Andover, KSBuilt 1973 · S/N 17262834 N13541Lowcountry Flying Club · Moncks Corner, SCBuilt 1976 · S/N 17702434 N13543Skylink II LLC · Florissant, MOBuilt 1973 · S/N 17262836 N13544Registered aircraftBuilt 1973 · S/N 17262837 N13548Havana Flyers Assoc · Petersburg, ILBuilt 1973 · S/N 17262840 N13549Big Sky Communication & Cable Inc · Billings, MTBuilt 1973 · S/N 17262841 N1354UVosskuhler Darlene Duke · Sun City West, AZBuilt 1976 · S/N 17267025 N13551Eagle Sky Patrol Inc · Deadwood, SDBuilt 1973 · S/N 17262843 N13552Newton Property Leasing LLC · Greene, IABuilt 1973 · S/N 17262844 N13555Krueger Steven T · Leander, TXBuilt 1973 · S/N 17262846 N13559Bauta Carlos L · Bristol, INBuilt 1973 · S/N 17262848 N1355FChi Aerospace Inc · Portsmouth, NHBuilt 1979 · S/N 17272998 N1355RFly Guys LLC · Arcata, CABuilt 1975 · S/N AA5-0755 N1355WBloch Matthew William · Marquette, MIS/N 2636 N13564Cain James W · Big Rapids, MIBuilt 1976 · S/N 17702437 N13565Williams Jim J · Jackson, NJBuilt 1976 · S/N 17702438 N1356FJprg Aviation Inc · Orlando, FLS/N 17272999 N1356UN1356u LLC · Wilmington, DEBuilt 1976 · S/N 17267027 N1356YBoggs John D · Duncan, OKS/N B-1 N13573Davis Flying Services LLC · Gaithersburg, MDBuilt 1973 · S/N 17262856 N1357CSummit Concepts Inc · Wilmington, DES/N 17702710 N1357UHarte Ryan D · Lone Star, TXBuilt 1976 · S/N 17267028 N13586Oreilly Thomas P · Oscoda, MIBuilt 1973 · S/N 17262860 N13587Nasairs Flying Club · Strongsville, OHBuilt 1973 · S/N 17262861 N1358ASchroeder Herbert P · Eagle River, AKBuilt 1951 · S/N 18-1184 N1358TMizera David · Hillsboro, ILBuilt 1972 · S/N 28-7225481 N1358UWaddill Paula J · Puryear, TNBuilt 1976 · S/N 17267029 N1358WDavis Charles S · Fairfield Bay, ARBuilt 1964 · S/N 2722 N13590Habibelahian Hamid Reza · Jefferson, TXS/N 17262863

Back to AD 80-04-03 R2