Registered aircraft · 68

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:87-19-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-19-01') 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:87-19-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-19-01')
  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:87-19-01')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-19-01')
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.

N101MZBohonis David C · North DeltaNon-citizen corporation, flight hours not reportedBuilt 1980 · S/N 5045 N102UMTimberland Helicopters Inc · Ashland, ORBuilt 1981 · S/N 5075 N105GKBank Of Utah Trustee · Salt Lake City, UTBuilt 1980 · S/N S-458 N105SDHeli Flite Inc · Corona, CABuilt 1998 · S/N 2052 N10MYBoston Executive Helicopters LLC · Norwood, MABuilt 1991 · S/N 5500 N124EHJbp Aviation LLC · Henderson, NVS/N S559 N131AEAtwood Aviation LLC · Pickerington, OHBuilt 1988 · S/N S787 N13TZAerospace Trust Management LLC Trustee · Wilmington, DES/N S550 N156HMSky West Aviation Inc Trustee · Albuquerque, NMS/N S-608 N16UAE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 1984 · S/N 47141 N179MTAnalar Corp · Princeton, NJS/N 5183 N202SCNs Air Leasing LLC · Wilmington, DEBuilt 1982 · S/N 5204 N2042XBell Textron Inc · Fort Worth, TXS/N 47099 N222EXNixon Eric J · Mentone, CABuilt 1980 · S/N 47043 N222FZCdh Enterprises LLC · Englewood, COS/N 47073 N222LBAerospace Trust Management LLC Trustee · Wilmington, DES/N 47071 N222LLKauffman Land & Development LLC · Ft Lupton, COBuilt 1981 · S/N 47060 N222XZSunwest Construction Enterprises Inc · Tarpon Springs, FLS/N 47048 N222ZXSunwest Construction Enterprises Inc · Tarpon Springs, FLS/N 47011 N223HXJonam LLC · Wilmington, DEBuilt 1984 · S/N 47511 N22ZWSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 47031 N29KHInternational Air Services Inc Trustee · Carson City, NVBuilt 1981 · S/N 47053 N30836Cornerstone Financial Enterprises LLC · Mesquite, NVBuilt 1980 · S/N 47036 N322AW541 East Liberty LLC · Savannah, GABuilt 1987 · S/N 47151 N327MHMaritime Helicopters Inc · Homer, AKBuilt 1989 · S/N S813 N3307HCdh Enterprises LLC · Tualatin, ORS/N 47076 N34NRInternational Air Services Inc Trustee · Carson City, NVBuilt 1982 · S/N 47068 N3538TSan Juan Aviation LLC · Wilmington, DERegistration expired, pending cancellationBuilt 1977 · S/N S-350 N355AGHover-Views Unlimited Inc · Syosset, NYBuilt 1982 · S/N 5109 N355ERElite Rotorcraft LLC · Mt Juliet, TNBuilt 1990 · S/N 5436 N355FFRichards William · Gardiner, NYBuilt 1982 · S/N 5133 N355HCAm Air Service LLC · Green Oaks, ILS/N 5184 N355HRNext Level Aviation LLC · Pflugerville, TXBuilt 1991 · S/N 5473 N355JCMavana As LLC · Miami, FLS/N 5517 N355SFHowe Aviation LLC · Surprise, AZS/N 5054 N355THTimberland Helicopters Inc · Ashland, ORBuilt 1981 · S/N 5111 N38VABrown Helicopter Inc · Pensacola, FLBuilt 1993 · S/N 2040 N477CSRegistration Pending · Spearfish, SDRegistration pendingBuilt 1994 · S/N 2045 N478CSRegistration Pending · Spearfish, SDRegistration pendingBuilt 1998 · S/N 2053 N4VEGreenway Avia Inc · Leesburg, FLS/N 47142 N525ZDg&R LLC · Murray, UTBuilt 1977 · S/N S-349 N52ZXRichard Schuman LLC · Kailua, HIS/N 5515 N549VSVertol Systems Co Inc · Destin, FLBuilt 1981 · S/N S-549 N554RPTwin Rotors Flying Circus LLC · Port Orange, FLBuilt 1973 · S/N S-111 N5BGLinscott Jeffrey Rodman · Boring, ORBuilt 1988 · S/N S799 N624TDEurotec Vertical Flight Solutions LLC · Eudora, KSS/N 5459 N627TDEurotec Vertical Flight Solutions LLC · Eudora, KSS/N 5460 N633MBCenterline Holdings Inc · Camden, DEBuilt 1986 · S/N S-750 N642ABCatalyst Aviation LLC · Hammonton, NJBuilt 1991 · S/N 5498 N65DACenter For Vertical Studies LLC · Sheridan, WYBuilt 1991 · S/N S-854

Back to AD 87-19-01