Skip to content

Iar Sa Brasov IAR 823

Registered aircraft · 35

Aircraft of this model in the FAA registry, by N-number.

Query with SQL

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN ('05607X6')
  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, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('05607X6')
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.

N103DJChicoine Chris · Williston, VTS/N 50 N10MXChihuahua Airport Partners Lp · Plano, TXS/N 76 N11VABrutsman Ross W · Hamilton, MTBuilt 1975 · S/N 20 N121ARGold Mountain LLC · Kalispell, MTBuilt 1979 · S/N 53 N129GCBlue Air Training Corp · Las Vegas, NVBuilt 1980 · S/N 55 N197ATBlue Air Training Corp · Las Vegas, NVBuilt 1974 · S/N 07 N2087PGold Mountain LLC · Kalispell, MTBuilt 1977 · S/N 36 N2114ZEagle & Associates LLC · Lake City, FLBuilt 1982 · S/N 75 N218BWRoelofs David M · Prescott, AZBuilt 1975 · S/N 18 N455NMMoore Daniel O · Fairfield, CAS/N 48 N47XXEagle Air LLC · Boulder, COBuilt 1977 · S/N 30 N61289Huff Zachary Daniel · Mesa, AZBuilt 1974 · S/N 03 N6134JBlue Air Training Corp · Las Vegas, NVBuilt 1974 · S/N 08 N6135BOlds Todd · Huntersville, NCBuilt 1978 · S/N 45 N66KBNorris Victor H · Bremerton, WABuilt 1976 · S/N 22 N680MGKennedy Arthur · Clovis, NMBuilt 1975 · S/N 54 N823AAAnduze Helicopter LLC · West Palm Beach, FLBuilt 1977 · S/N 32 N823BBCampbell Bruce A · Sammamish, WAS/N 04 N823BCGrounded No More Veteran Flight Lift LLC · Queen Creek, AZS/N 31 N823CKelly Mark D · Whitefish Bay, WIBuilt 1982 · S/N 73 N823DCSwanberg Charles Marvel · Sandia Park, NMBuilt 1983 · S/N 78 N823DJHill Robert L · Kenmore, WABuilt 1975 · S/N 05 N823DKKeck Joseph · Bittmore Lake, NCBuilt 1975 · S/N 17 N823EHRogers Derek P · Lawrence, KSBuilt 1977 · S/N 33 N823HRBlue Air Training Corp · Las Vegas, NVNon-citizen corporation, flight hours not reportedBuilt 1981 · S/N 68 N823JTJohnson Thomas Cavanagh · Scottsdale, AZBuilt 1976 · S/N 27 N823KUGeaney Joseph P III · Cabot, ARBuilt 1979 · S/N 51 N823PBBrown Scott · Aguanga, CABuilt 1979 · S/N 49 N823RMRegistration Pending · Las Vegas, NVRegistration pending, pending cancellationBuilt 1977 · S/N 35 N823SHBlue Air Training Corp · Las Vegas, NVBuilt 1975 · S/N 12 N823TABlue Air Training Corp · Las Vegas, NVBuilt 1981 · S/N 71 N823WLigon Robert E III · Warner Robins, GABuilt 1976 · S/N 25 N823WTHillerman David A · Denair, CABuilt 1976 · S/N 24 N823YHoyt Charles · Wadsworth, OHBuilt 1982 · S/N 06 N9047FOwens Todd C · Marietta, GABuilt 1977 · S/N 34

Back to Iar Sa Brasov IAR 823