OpenAirDocs.org
AD 2004-22-13

Registered aircraft · 312

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

N4338DAce High Helos LLC · Louise, TXBuilt 1992 · S/N 51560N43AEAir Evac Ems Inc · O Fallon, MOBuilt 1978 · S/N 45187N447JBJbi South Leasing LLC · Pembroke, NHBuilt 1980 · S/N 45415N449EAEdgefield Aviation LLC · Sandy, ORBuilt 1982 · S/N 51027N461RARanger Aviation Leasing LLC · Wilmington, DES/N 45461N468RLMarks Lloyd L · Lafayette, LABuilt 1985 · S/N 51155N4717WSeven Whiskey LLC · Austin, TXS/N 51124N477SDHigh-Lead Helicopters LLC · Mossyrock, WABuilt 1990 · S/N 51343N4833Gm Leasing Co LLC · Broussard, LABuilt 1989 · S/N 51285N4846G M Leasing Co LLC · Broussard, LABuilt 1987 · S/N 51200N48AEAir Evac Ems Inc · O Fallon, MOBuilt 1980 · S/N 45562N4KAAmbrose Group Inc · Bellevue, WABuilt 1992 · S/N 51578N5000BAir Flite Inc · Shawnee, OKS/N 51044N5000GTimberland Helicopters Inc · Ashland, ORBuilt 1978 · S/N 45163N50046Orlando Aircraft Sales LLC · Orlando, FLBuilt 1978 · S/N 45173N5007FPatriot Aviation Inc · Greenville, DENon-citizen corporation, flight hours not reportedBuilt 1978 · S/N 45186N5013GHmc Lift LLC · Wilmington, DEBuilt 1979 · S/N 45254N5017GHelimontana.Com LLC · Livingston, MTBuilt 1979 · S/N 45228N505RLOrgis Bj · Hallettsville, TXBuilt 1978 · S/N 45176N514RLSlikker Flying Service Inc · Buttonwillow, CABuilt 1991 · S/N 51514N516LERotor Republic LLC · Orlando, FLBuilt 1978 · S/N 45162N52AEAir Evac Ems Inc · O Fallon, MOS/N 45758N52GHPleasant Gap Land Co Inc · State College, PABuilt 1989 · S/N 51276N52PLParatus Air DBA · Auburn, INS/N 45744N53702Helicopter Applicators Inc · Gettysburg, PABuilt 1983 · S/N 51249N53AEAir Evac Ems Inc · O Fallon, MOS/N 45300N545SAShier Aviation Corp · San Diego, CABuilt 1983 · S/N 51063N54AEAir Evac Ems Inc · O Fallon, MOBuilt 1978 · S/N 45157N54NYWisk Aero LLC · Mountain View, CABuilt 1983 · S/N 45770N54SPIndiana State Police · Indianapolis, INS/N 51062N560PK&D Aviation LLC · Kingston, OKBuilt 1982 · S/N 51013N566AFRickards Aviation Group LLC · Dagsboro, DEBuilt 1981 · S/N 45565N570JHHarnden Aviation Group LLC · Harrisburg, PABuilt 1980 · S/N 45428N570LEHhl LLC · Denver, COS/N 45570N570RLJasons Helicopter Services · New Prague, MNBuilt 1980 · S/N 45517N571CJRotorpro LLC · Sevierville, TNBuilt 1983 · S/N 45781N57441Jbi South Leasing LLC · Pembroke, NHBuilt 1980 · S/N 45438N5745YMonarch Enterprises Inc · Kirkland, WABuilt 1980 · S/N 45531N57491Monarch Enterprises Inc · Kirkland, WABuilt 1980 · S/N 45505N5751MTrinkle Aviation LLC · Kingburg, CABuilt 1980 · S/N 45522N583MS & S 1165 Investments LLC · Austin, TXBuilt 1992 · S/N 51583N5843Gm Leasing Co LLC · Broussard, LABuilt 1991 · S/N 51467N588MAMercury Aviation Inc · Flowood, MSS/N 51350N595AEAir Evac Ems Inc · O Fallon, MOBuilt 1979 · S/N 45244N59AEAir Evac Ems Inc · O Fallon, MOBuilt 1979 · S/N 45291N59CHAir Center Helicopters Inc · Burleson, TXS/N 45284N601GMNorth Wind Aviation LLC · Cottage Grove, ORBuilt 1981 · S/N 45638N601SJAg Air Inc · Longmont, COBuilt 1985 · S/N 51128N60VGFarwest Aviation LLC · Billings, MTBuilt 1991 · S/N 51494N6133CRedlands Heli Flight LLC · Redlands, CABuilt 1991 · S/N 51544
Back to AD 2004-22-13