Registered aircraft · 1,223

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:2005-10-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:2005-10-13') 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:2005-10-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:2005-10-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.

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:2005-10-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:2005-10-13')
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.

N100ATWestern Pacific Fisheries · Hermosa Beach, CABuilt 1980 · S/N 500718D N100LMHaddock Flying Service Inc · Salters, SCS/N 1583 N100NJAlba Leasing Services LLC · Scottsdale, AZBuilt 1987 · S/N 3992 N101ALRegistered aircraftBuilt 1980 · S/N U20605684 N101CHTri-State Vegetation Management LLC · Vevay, INS/N 1000829D N101DGSummit Helicopters Inc · Salem, VABuilt 1986 · S/N 3929 N101MZBohonis David C · North DeltaNon-citizen corporation, flight hours not reportedBuilt 1980 · S/N 5045 N102CGSale Reported · Surprise, AZSale reported, pending cancellationBuilt 1998 · S/N LNO85 N102UMTimberland Helicopters Inc · Ashland, ORBuilt 1981 · S/N 5075 N104APRock Creek Leasing LLC · Sapulpa, OKBuilt 1990 · S/N 4149 N104HHHaddock Flying Service Inc · Salters, SCBuilt 1960 · S/N 2062 N104RLVertical Vegetation Management LLC · Darlington, INS/N 4315 N104SUSignature Property Holdings LLC · Wilmington, DEBuilt 1977 · S/N 670151D N105ACAgricultural Air Services LLC · Jupiter, FLBuilt 1978 · S/N 580316D N105APBearing Tree Land Surveying LLC · Oklahoma City, OKBuilt 1995 · S/N 4381 N105ATQualitair LLC · MichelstadtBuilt 2006 · S/N 4601 N105GKBank Of Utah Trustee · Salt Lake City, UTBuilt 1980 · S/N S-458 N105HHHaddock Flying Service Inc · Salters, SCS/N 1307 N105JDHavens Aviation LLC · Blacklick, OHBuilt 1973 · S/N 1105 N105LCCenterline Holdings Inc · Camden, DEBuilt 1988 · S/N S789 N105LHHelilease LLC · Lewes, DEBuilt 1979 · S/N 2185 N105SUSignature Property Holdings LLC · Wilmington, DEBuilt 1988 · S/N 800776D N106AMJasons Helicopter Services LLC · New Prague, MNBuilt 1974 · S/N 1384 N106JCTrans Peco Aviation LLC · Fort Stockton, TXBuilt 1982 · S/N 3622 N106SUSignature Property Holdings LLC · Wilmington, DEBuilt 1981 · S/N 510954D N1075WSan Juan Aviation LLC · Wilmington, DEBuilt 1980 · S/N 45377 N1076GHenderson Aviation Co · Junction City, ORBuilt 1979 · S/N 2831 N1078QAris Leasing Inc · Sunnyvale, CABuilt 1978 · S/N 2425 N107GGCarbon River Helicopter Services LLC · Lexington, KYBuilt 1980 · S/N 2917 N107LHHelilease LLC · Lewes, DEBuilt 1978 · S/N 2423 N107PHSouthern Helicopter Service Inc · Millington, TNBuilt 1979 · S/N 2789 N107SFDah Aircraft LLC · Georgetown, SCBuilt 1978 · S/N 1280405D N1080NReynolds Aviation LLC · Wills Point, TXBuilt 1981 · S/N 3549 N1081KMarks Aviation Group LLC · Lafayette, LABuilt 1980 · S/N 45407 N1085BDel Rio Aviation Inc · Paso Robles, CABuilt 1980 · S/N 2908 N108DRParamount International Inc · Millville, NJBuilt 1976 · S/N 1875 N108ECHva Inc · Summersville, WVBuilt 1982 · S/N 811049D N108LHHelilease LLC · Lewes, DEBuilt 1978 · S/N 2426 N108PPCity Of Pomona · Pomona, CABuilt 2008 · S/N 0578E N1097JSignature Property Holdings LLC · Wilmington, DEBuilt 1980 · S/N 900801D N109CYO'Brien Derrick P · Middletown, DES/N 7351 N109LBVertol Systems Company Inc · Destin, FLBuilt 1991 · S/N 0455E N109MMAirborne Leasing Inc · Sylmar, CABuilt 1985 · S/N 7279 N109PBBennedsen Rosa Fadia Gabriel · Aventura, FLBuilt 1985 · S/N 7344 N109RASunny Sky LLC · Stacyville, IABuilt 1979 · S/N 2741 N109USU S Helicopters Inc · Marshville, NCBuilt 1977 · S/N 2164 N109WGDodson International Parts Inc · Rantoul, KSS/N 7316 N109WJL S Service Corp · Wilmington, DEBuilt 1982 · S/N 7218 N109XPNational Test Pilot School · Mojave, CABuilt 1981 · S/N 7178 N10AJEl Aero Services LLC · Elko, NVBuilt 1980 · S/N 3169

Back to AD 2005-10-13