Registered aircraft · 132

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:83-15-07-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:83-15-07-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:83-15-07-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:83-15-07-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:83-15-07-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:83-15-07-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.

N444CRUtah State University · Logan, UTBuilt 2012 · S/N 4578 N44UHAlba Leasing Services LLC · Scottsdale, AZBuilt 2015 · S/N 4677 N456UHAlba Leasing Services LLC · Scottsdale, AZBuilt 2014 · S/N 4655 N521RLCherry Creek School District No 5 · Greenwood Village, COS/N 0216 N522SBTrinity Aviation LLC · Georgetown, TXBuilt 2021 · S/N 4845 N555UHAlba Aviation Services Inc · Scottsdale, AZBuilt 2004 · S/N 3550 N559DDRobinson Helicopter Co Inc · Torrance, CAS/N 3299 N5643Fingerlakes Wing And Rotor LLC · Seneca Falls, NYS/N 4033 N574RJJets To Helis LLC DBA · Chandler, AZBuilt 2023 · S/N 4888 N577ZZRubey Arthur C · San Antonio, TXBuilt 2024 · S/N 4903 N597LELeading Edge Aviation Inc · Bend, ORBuilt 1986 · S/N 597 N6153FEmployment Services Inc T/A · Virginia Beach, VAS/N 0091 N617DRRadford David M · Glen Cove, NYBuilt 2018 · S/N 4791 N6262XGriggs Levi · Morganfield, KYBuilt 1981 · S/N 0226 N67010Robinson Helicopter Company Inc · Torrance, CABuilt 1975 · S/N 0001 N6703SSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 2004 · S/N 3621 N674RGTech Heli LLC · Fort Lauderdale, FLBuilt 1998 · S/N 2885 N689MBoatphoto Helicopter LLC · Rebhoboth, DES/N 689M N7019EShimek Mark S · Port Lavaca, TXBuilt 1980 · S/N 0068 N7064DLippincott David H · San Diego, CABuilt 1999 · S/N 2907 N706JJJj Helicopters Inc · Torrance, CABuilt 2008 · S/N 4306 N712UTumbleweed Leasing Co Inc · Salt Lake City, UTBuilt 2004 · S/N 3676 N71GARosso Corsa Motors Inc · Colorado Springs, COBuilt 2004 · S/N 3727 N724JHJets To Helis LLC DBA · Chandler, AZBuilt 2018 · S/N 4777 N726KDRobinson Helicopter Co · Torrance, CAS/N 4961 N744ESUsaircraft Inc · Newark, DEBuilt 1993 · S/N 2319 N74GNStuckey Connections LLC · Magnolia, TXBuilt 2018 · S/N 4768 N7686HTotal Flight Aircraft Leasing LLC · Apex, NCS/N 4348 N777UHRobinson Helicopter Company Inc · Torrance, CABuilt 2004 · S/N 3548 N781SHNorth American Rotorcraft LLC · Santa Rosa, CABuilt 2004 · S/N 3613 N782SHJtc Aviation LLC · Nashville, TNBuilt 2004 · S/N 3616 N783SHKmc Aircraft Leasing LLC · Spanish Fork, UTBuilt 2004 · S/N 3617 N786SHSpitzer Helicopter LLC · Woodland Hills, CABuilt 2004 · S/N 3626 N788SHSouthwest Technology Center School Dist No. 27 · Altus, OKBuilt 2004 · S/N 3631 N790SHMichael Mollere Inc · Marion, TXBuilt 2004 · S/N 3636 N791SHSpitzer Helicopter LLC · Woodland Hills, CABuilt 2004 · S/N 3637 N795SHLange Helicopters Inc · San Angelo, TXS/N 3728 N79FCSulpher Creek Helicopters LLC · George West, TXBuilt 2007 · S/N 4137 N819GLRobinson Helicopter Co · Torrance, CAS/N 4966 N824WSHampton Roads Charter Service · Chesapeake, VABuilt 2004 · S/N 3606 N826GBerger Daniel · Edgewood, NMBuilt 2024 · S/N 4899 N826SFN115vg LLC · Princeton, NJBuilt 2015 · S/N 4673 N827SCSpitzer Helicopter LLC · Wilmington, DES/N 4720 N8364QBlinn Philipp Randy · Priest River, IDBuilt 1982 · S/N 0311 N83666Baugh Aviation Inc · Lebanon, TNBuilt 1982 · S/N 0314 N8398AKeller William F · Burbank, CABuilt 1983 · S/N 0344 N8403LAarow Aircraft Leasing LLC · Mcminnville, ORBuilt 1983 · S/N 0347 N8416JEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1983 · S/N 0359 N842SVPylon Aviation Services LLC · Chandler, AZBuilt 1983 · S/N 0366 N8439MSteel Supply Co · Rolling Meadows, ILS/N 0371

Back to AD 83-15-07 R1