Registered aircraft · 1,150

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:90-13-01-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:90-13-01-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:90-13-01-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:90-13-01-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:90-13-01-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:90-13-01-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.

N67952City Of Jackson Tennessee · Jackson, TNBuilt 1995 · S/N 5230 N67960Dakota Air Parts International Inc · Fargo, NDBuilt 1995 · S/N 5232 N67961Brown Helicopter Inc · Pensacola, FLBuilt 1995 · S/N 5233 N67968United States Army · Redstone Arsenal, ALBuilt 1995 · S/N 5235 N67978Mf Helicopters LLC · East Troy, WIBuilt 1995 · S/N 5237 N679AGUsda Aphis Wildlife Services · Cedar City, UTBuilt 1994 · S/N 5188 N67CLHelicopters Inc · Linden, NJBuilt 2000 · S/N 4530 N67FABas Part Sales LLC · Greeley, COBuilt 1994 · S/N 5168 N67JJTre Aviation Corp · Wilmington, DES/N 4062 N67SJSan Juan Aviation LLC · Wilmington, DES/N 51098 N682BHBa Group LLC · Glastonbury, CTBuilt 2009 · S/N 4682 N68AEAir Evac Ems Inc · O Fallon, MOBuilt 1981 · S/N 45647 N68GGJa Aviation Services LLC · Kalispell, MTBuilt 1975 · S/N 1792 N68PHMercury Aviation Inc · Flowood, MSBuilt 1988 · S/N 3988 N695MCTom Cline Helicopter LLC · Lake Ozark, MOBuilt 1968 · S/N 300 N69875Gateway Youth Aeronautical Foundation · Maryland Heights, MOBuilt 2001 · S/N 5282 N6BUAgricultural Air Services LLC · Jupiter, FLBuilt 1988 · S/N 4034 N6QDSierra Golf Rotorcraft LLC · Wilmington, DEBuilt 1992 · S/N 4247 N6WVState Of West Virgina Dept Of Avn · Charleston, WVS/N 3138 N701HAHelo N701ha LLC · Richmond, VABuilt 2001 · S/N 4554 N70606Registration Pending · Rome, NYRegistration pendingBuilt 1989 · S/N 51282 N706CCCertified Aviation LLC · Wilmington, DEBuilt 1976 · S/N 2119 N707MKSch Aviation Inc Trustee · NorfolkBuilt 2007 · S/N 4633 N707SJCtrg Aviation Holdings LLC · Lakeway, TXBuilt 1981 · S/N 3561 N70SPGreat Plains Aircraft Holding LLC · Papillion, NEBuilt 1968 · S/N 238 N710HPHendrickson Flying Service Inc · Rochelle, ILS/N 1755 N711TTFaithful Flyers LLC · Lakeside, CABuilt 1991 · S/N 51433 N711ZWMalmrose Heli Services Inc · North Salt Lake, UTBuilt 1979 · S/N 2691 N712MScotts Helicopter Service Inc · Le Sueur, MNBuilt 1983 · S/N 51072 N712WRTrans Texas Helicopter Services LLC · Realitos, TXS/N 2044 N713BCTimcoaviation LLC · Purvis, MSBuilt 1982 · S/N 3671 N7159HPremier Rotors LLC · Saint Martinville, LABuilt 1990 · S/N 51397 N716VLAirwayplanner.Com LLC · Sands Point, NYBuilt 1992 · S/N 4203 N71JJInterstate Helicopters Inc · Bethany, OKBuilt 1989 · S/N 51329 N71WPSimjet Center Inc · Granbury, TXS/N 2702 N720BGentem Inc Trustee · Wilmington, DEBuilt 1980 · S/N 45452 N7250EAg Air Inc · Oakdale, CABuilt 1974 · S/N 1529 N726HGm Leasing Company LLC · Broussard, LABuilt 1992 · S/N 51548 N727BBDle Corp · Lewes, DES/N 735 N73AJGreenway Avia Inc · Wilmington, DES/N 922 N73AMMetroplex Flight Services LLC · Fort Worth, TXS/N 3473 N744TVU S Helicopters Inc · Marshville, NCBuilt 1985 · S/N 3863 N74678Southmark Aviation Inc · Hattiesburg, MSBuilt 2001 · S/N 5274 N747DMHunter Construction Group Inc · Mooresville, NCBuilt 1981 · S/N 3510 N749FFHunt-Lo Farms LLC · Chesterland, OHBuilt 1983 · S/N 45773 N74AJAerial Control Inc · Brentwood, CABuilt 1979 · S/N 2751 N7508PReece Michael · Marathon, FLBuilt 2006 · S/N 4611 N75454Realstaff Rocket LLC · Salem, ORS/N 5280 N758ERPer-Dar Helicopter LLC · Houston, TXBuilt 1976 · S/N 2058 N75CWChem Air LLC · Shreveport, LABuilt 1975 · S/N 1762

Back to AD 90-13-01 R1