Skip to content

Registered aircraft · 2,552

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:76-08-02-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:76-08-02-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:76-08-02-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:76-08-02-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:76-08-02-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:76-08-02-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.

N59MRFly Bravo LLC · Jasper, TXBuilt 1959 · S/N 35929 N59NMGf Air LLC · Las Vegas, NVBuilt 1975 · S/N 421B0870 N59RLBurton Donald O · Mooresville, NCBuilt 1959 · S/N 35946 N59TGT Stanco Inc · Jasper, GAS/N 35792 N5CHHartshorn William T · Tucson, AZBuilt 1968 · S/N 421-0113 N5CXGumar Sherko A · Scottsdale, AZBuilt 1975 · S/N 310R0224 N5HSRose Raymond P · San Diego, CABuilt 1962 · S/N 320A0026 N5LHIsland Creek Partners LLC · Alpine, CABuilt 1973 · S/N 310Q0939 N5PJGod Family Ministries International Inc · Elmont, NYBuilt 1972 · S/N 421B-0258 N5VXParrott Land & Cattle LLC · Roundup, MTBuilt 1958 · S/N 35797 N5YFBas Part Sales LLC · Greeley, COBuilt 1967 · S/N 310L-0084 N5ZTAllen Airplane LLC · Durango, COBuilt 1973 · S/N 414-0477 N600EXAire Tracks Corp · Wilmington, DEBuilt 1969 · S/N 310P0147 N600RRCompac Inc · Manassas, VABuilt 1963 · S/N 310H0108 N600SMCapt Tony 185 LLC · Aurora, COBuilt 1966 · S/N 320E0084 N606PPAndriopulos Salguero Inc · Hialeah, FLS/N 414-0416 N6098XKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1978 · S/N 310R1266 N60FYNew Castle Aviation Inc · Durham, NHBuilt 1969 · S/N 310P0109 N6101XJanhar Ales · Danville, CAS/N 310R1267 N6104XTerairmar Services Inc · Monticello, FLBuilt 1978 · S/N 310R1272 N6109XBlake Development Corp LLC · Fort Lauderdale, FLS/N 310R1278 N610AKBaja Electric Service Inc · Punta Gorda, FLBuilt 1974 · S/N 310Q-1072 N610RCHallada William A · Barnesville, GAS/N 310-0115 N610W610w Holdings LLC · Sandy, UTS/N 310R-0322 N6116CWaukegan Flyers LLC · Waukegan, ILBuilt 1978 · S/N 310R1283 N611UParker Robert T Jr · Bigfork, MTS/N 35106 N6126CM20k LLC · Minot, NDBuilt 1978 · S/N 310R1293 N612CGCasa Grande Homes Inc · Blanchard, OKBuilt 1973 · S/N 421B0416 N612JPSkyline Air LLC · Ashburn, VABuilt 1968 · S/N 310N-0116 N6131XGv Air Inc · Medford, ORS/N 310R1296 N6137XMoyer Aviation Inc · Ulysses, KSBuilt 1978 · S/N 310R1297 N6142CKite Harris Property Group LLC · Zionsville, INS/N 310R1300 N614CQC & H Aviation LLC · Lagrange, GABuilt 1977 · S/N 310R1239 N6151QNitro Zeus Inc · Wilmington, DEBuilt 1967 · S/N 320F-0001 N6152XPakan Dwight John · Charlotte, NCBuilt 1978 · S/N 310R1302 N6156QGem State Transportation Inc · Hamilton, MTBuilt 1967 · S/N 320F-0006 N616DFugate Kirk A · El Dorado Springs, MOS/N 421B0140 N616RMMnemonics Inc · Melbourne, FLBuilt 1973 · S/N 414-0375 N6176XCentral Texas College · Killeen, TXFirst renewal noticeBuilt 1978 · S/N 310R1315 N6177XMayhew William D · Round Lake, ILBuilt 1978 · S/N 310R1316 N6180CBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 1978 · S/N 310R1318 N6181C6181c LLC · Saginaw, MIBuilt 1978 · S/N 310R1320 N6184QMarc Inc · Bolton, MSBuilt 1968 · S/N 320F-0034 N6186XSaint Louis Cessna Group LLC · Saint Louis, MOBuilt 1978 · S/N 310R1325 N6192XSongbird Group LLC · Andover, MNBuilt 1978 · S/N 310R1329 N6193QRedstar Air Shows Inc · Discovery Bay, CAFirst renewal noticeBuilt 1968 · S/N 320F-0043 N6194ZNeel Aviation LLC · Lakeland, FLS/N 35378 N6195QSunny Aviation LLC · Kalispell, MTBuilt 1968 · S/N 320F-0045 N6195XSlc Service Leasing Company LLC · Tipton, IABuilt 1978 · S/N 310R1331 N61DSHouston Aeronautical Heritage Society Inc · Houston, TXS/N 35317

Back to AD 76-08-02 R2